Why you should not update Primary Key values
Recently I had the chance to take a look at a problematic query in an application. I caught the query in profiler and it’s the following: [crayon-5e81b52edda2c602772598/] The query...
2015-11-11
9 reads
Why you should not update Primary Key values
Recently I had the chance to take a look at a problematic query in an application. I caught the query...
2015-11-11
3,399 reads
Sql Hints #1 - Don’t update Primary Key values
Recently I had the chance to take a look at a problematic query in an application. I caught the query...
2015-11-11
110 reads
Webinar: Unit Testing with SQL Server and tSQLt
I ran into Sebastian Meine at the PASS Summit a few weeks ago and we were talking testing. Sebastian is...
2015-11-11
676 reads
Question: Single SQL Server VM on One Host Justifications
Earlier this week I received a great question from a friend, and read something like this.
Hi David,I usually recommend people...
2015-11-11
402 reads
Updating Extended Properties
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers.
I...
2015-11-11
638 reads
Veterans Day – Thank You for Your Service
If you currently serve or have served in our military, thank you for your service. Please never doubt that your...
2015-11-11
427 reads
Did PASS Forget the DBA?
Today I had on my list to finish watching the presentation Gail Shaw did at Summit 2014, one of the...
2015-11-11
456 reads
Support for SSMS 2016 now available
Good news!
Red-Gate published new version of its SIPF framework with support of SSMS 2016!
Now you can simply download and install...
2015-11-11
549 reads
Don't Trust the Wizard
If you need to move data from one table into a new table, or even tables in a database into another database, the Import/Export Wizard in SQL Server Management...
2015-11-11
13 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
advice on ssrs version control
Hi we're a bit behind on versioning ssrs. I think we have over 1600...
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers