| A community of more than 1,600,000 database professionals and growing |
| | | Bring Solutions This editorial was originally published on Feb 13, 2013. It is being re-run as Steve is out of the office. What's your job? Most of you will answer "DBA", or "developer", or "manager", or something that corresponds to your title. That's partially true, but for the most part if you are in Information Technology, I think your job is to solve problems. You should ensure that your systems, or your code, or whatever you work on, is running smoothly for the people that use them. That isn't always possible. There will be times that things break, that bugs crop up or systems fail. When that happens, people don't want to hear about the inherent problems, or even what went wrong. They might ask, and they might be curious, but really what they want to know is when will the system be fixed and what will it cost. I've never had a manager that was really interested in the problems that caused a failure when systems were down. I've rarely had managers interested in potential problems I've noticed in our organization. Managers might be curious about the issues, but they don't want you to bring them problems. They want you to bring them solutions when you see a problem, multiple choices to fix things, and a recommendation for the option you feel is best. They want a solution that works well, doesn't cost a lot, and can be implemented quickly. Competition for jobs gets more intense all the time and the employees that look for problems and provide solutions without being asked will be the most valuable. They will stand out from their peers and are more likely to not only keep their jobs during down times, but will get asked to solve the interesting and challenging problems. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT | | | | How can you help your team write better, shareable SQL faster? Find out by discovering 15 Super SQL Tips from Microsoft MVPs and other SQL Server experts. Using SQL Prompt to write, refactor, and share SQL, they show how it strips away the repetition of coding and standardizes it everywhere. View the tips and download a free trial. |
| | | | Track schema changes for free DLM Dashboard tracks SQL Server databases to show you exactly what schema changes have been made, by who, and when. You get a full history, with line-by-line differences, and a clear audit trail of your database moving from development to production. Download free tool. |
| | | | Free SSMS add-in: SQL Search Redgate SQL Search is a free SSMS add-in that lets you find fragments of SQL across multiple objects and multiple databases. Once installed, SQL Search appears on the SSMS toolbar, allowing you to quickly navigate to objects wherever they are on a server. Download SQL Search now. |
|
|
|
| | | | | Mike McQuillan from SQLServerCentral.com Tables used purely for reporting sometimes lack a unique identifier. Find out how to remove duplicates from such a table when data loads go bad. More » |
| | Additional Articles from Brent Ozar Unlimited Blog So you’re hosting your SQL Server in the cloud, and you’ve noticed that when you’re running a backup or a DBCC CHECKDB, you suffer from extreme performance problems - what's going on? Brent Ozar explains. More » |
| | Devin Knight from SQLServerCentral Blogs I’m just returning from an amazing week at PASS Summit where I meet many of you while working our Pragmatic... More » |
| | Enrico van de Laar from SQLServerCentral Blogs As most of you might know, I am a big fan of the Query Store feature inside SQL Server 2016.... More » |
|
|
| | | Today's Question (by Junior Galvão - MVP): Introduced in Microsoft SQL Server 2014 SP2, DBCC CloneDatabase aims to allow the investigation of performance problems in a query. This DBCC command has some usage restrictions. What are they? |
Think you know the answer? Click here, and find out if you are right. We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: DBCC. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| ADVERTISEMENT | | Professional Microsoft SQL Server 2014 Integration Services The 2014 release of Microsoft's SQL Server Integration Services provides enhancements for managing extraction, transformation, and load operations, plus expanded in-memory capabilities, improved disaster recovery, increased scalability, and much more. The increased functionality will streamline your ETL processes and smooth out your workflow, but the catch is that your workflow must change. New tools come with new best practices, and Professional Microsoft SQL Server 2014 Integration Services will keep you ahead of the curve. SQL Server MVP Brian Knight is the most respected name in the business, and your ultimate guide to navigating the changes to use Microsoft SQL Server Integration Services 2014 to your utmost advantage. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): When running sp_spaceused for years, I have gotten results like this: This gives me two result sets, which are hard to manage. On my new SQL Server 2016 instance, how can I get all of this data into a single result set in the easiest way possible?
Answer: Use the @oneresultset parameter set to 1 Explanation: The sp_spaceused procedure has a parameter, @oneresultset, which will return a single result set when set to 1. Ref: Sp_spaceused - https://msdn.microsoft.com/en-us/library/ms188776.aspx » Discuss this question and answer on the forums |
|
|
| | | Database Pros Who Need Your Help |
| | Here's a few of the new posts today on the forums. To see more, visit the forums. Management Studio hangs after query results - Hi, I recently discovered that when I query a table (anyone I've tested) and the results are more than 1000 rows,... Query returning incorrect results randomly - Hi Team, I'm running a simple SQL query which returns a set of columns based on a search criteria. It has... Table valued fucntion or scalar valued function - I have a productCase table that we created cases for some products. Then there are some other tables related with... Cluster Node Down - Hi Experts, One of our node in a 2 node SQL cluster is down . Checked the Port 3343 is open , no... MSDB jobs in DB mirroring and AlwaysOn availability group - Hi all, As we have already know -> system databases are not mirrored nor replicated in both mirroring and alwayson availability... How to use a CSV as parameter in a query - I always used a query with an(one) integer parameter, but now it has to change to more integers in the... Determine if a table column is used? - Does anyone know if there's any way you can determine if a column in a table is used or not? I... Sproc/view/function code parser - Hi - I'm looking for a code parser for SQL Server 2014 - ie something that I can point at a sproc... SUM and Group using IN clause - Hi, I am looking for a way to create a query to SUM and Group BY by using IN clause... Completing Fixed Sets With Another Table - Hi, I'm having some trouble finding a solution to a problem, its been a few hours now and I think I... Check my backup knowledge? - We've been having on and off space issues with a backup for a vended database. This backup is part of... Current options for data-change notification on a vendor-schema (unalterable) - I've got more and more applications popping up in my enterprise environment that would benefit from being notified when information... Execution Plan help. Estimates off by alot ! - Hello All, I need help on this execution plan. I recently made some changes to many of my tables. In my... AlwaysOn DRP test - discarding the changes in the DR replica - We are doing a DRP test on a large database, which is hosted on an AlwaysOn availablilty group with 3... Need help with a SQL "least significant digit" algorithm - Hi all, Looking for some quick help with a bit of SQL. The best way I can describe it is that... sp_settriggerorder in section TRY/CATCH - I have a problem with calling "EXEC sp_settriggerorder" when @TriggerName is not exists. After calling in TRY / CATCH section remains open... Big data: transfer x-number of rows per batch? - Hi all, I must transfer a big table (231k rows not that big, but 735GB big because of blob) to another... Username increment by 1 if already exists in table - Hi All, I am having user table as below Create table #TEMP_USER ( ID int identity (1,1) , USERNAME nvarchar(50) ); I want to insert... Migrating Data from SQL server 2012 to Data Warehouse - Hi, What do you think is the easiest way to migrate data from Sql server to data warehouse Importing Data and Default Values - Heya All, [b]SSIS 2008 R2[/b] (Data and Structure are made up) I am importing data into a Products tables. The table has... |
|
| This email has been sent to [email protected]. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the [email protected]. | This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here. | This transmission is ©2015 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: [email protected] |
|
|
