Object Grouping Best Practices: Using Schemas for Logical Separation
You've probably all noticed a change since SQL Server 2000 with respect to objects: formerly DB.ObjectOwner.Object ,
2009-07-14
2,920 reads
You've probably all noticed a change since SQL Server 2000 with respect to objects: formerly DB.ObjectOwner.Object ,
2009-07-14
2,920 reads
The goal of this post is to understand the procedure cache and execution plans to ensure we use fewer resources and that queries run better. Better means higher throughput, more concurrency and fewer resources – as described by MVP Joe Webb during SQLTeach in Vancouver just last month.
2009-07-08
1,134 reads
Originally written in French last year, now revised for you in my native language below:
You've probably all noticed a change...
2009-07-06
3,478 reads
The goal of this post is to understand the procedure cache and execution plans to ensure we use fewer resources...
2009-06-30
2,440 reads
During the process of applying changes to a production database - let's call it Change Management (pick your ITIL or COBIT...
2009-06-25
2,649 reads
The point of this post is to cleary explain how the combination of the use of data definition language for your temporary...
2009-06-11
1,096 reads
The goal of this post is to explain how to handle errors thanks to a useful T-SQL functionality, available since SQL 2005 onwards, that developers are already used to – and similar to how exceptions are handled in the Visual Studio environment.
2009-06-11
5,706 reads
This is based on the original post in Franglais.
The goal of this post is to explain how to handle errors...
2009-06-03
2,471 reads
The goal of this post is to explain how to take advantage of Auto-Retry and why you will want to use it. I hope to clarify in which circumstances an auto-retry works best and when not to use it also. The (disclaimer!) point is that every job has its own constraints, requirements, and has to be evaluated individually for whether an auto-retry will work. I will try and keep this summary short and crisp, but still with enough detail to understand auto retry best.
2009-06-01
3,877 reads
The goal of this post is to explain how to take advantage of Auto-Retry and why you will want to...
2009-05-27
7,150 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have a table. Structure in script below. I have to compare and see...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers