This movie was made for Conduit 5 years event: https://youtu.be/UKLOJTG2sBg
I play in Conduit promo movie :-)
I
Replication fun: setting NFR on all objects
R
If you ever tried to set up replication on the large environment with numerous servers, hundreds of databases then you, for sure, spend some time searching/writing scripts to set flag NOT FOR REPLICATION on thousands of identities,…
WITH (NOLOCK) still places locks !
W
Did you know, that when you use READ UNCOMMITTED isolation level or WITH (NOLOCK) hint inside the query, it is still places Sch-S (schema stability) locks during compilation and execution and can be blocked by any concurrent trancastion…
Back to the future: SQL Profiler Trace Replay
B
Are you familiar with Trace Replay feature SQL Profiler? It's not really popular but actually can do a lot for you.Replay is the ability to save a trace and replay it later. This functionality lets you reproduce activity captured in a…
See all locks that were issued by your query
S
If you ever wondedered what king of locks your selct query ever issues and for how long, run it in QA environment with isolation level Repeatable Read, which holds all locks you select issues till the end of transaction. Default isolation…
Nice SQL jokes
N
Q: Why do you never ask SQL people to help you move your furniture?A: They sometimes drop the table--------------------------------------A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join…
Exporting registered servers from SQL 2008
E
It appears that Registered servers are not being stored in the registry now. There is a file here C:\Documents and Settings\{you}\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\RegSrvr.xml that can be moved from server to…
Merging partitions in SQL 2005
M
Today I have played with partition merging. The target of this was to see how long it can take, which locks are being held etc.I see that even if partions are empty, the minimum time that it takes is 30 sec ( 2x2.66 CPU 7Gb RAM ). Most of…
Changing partition_id in SQL Server partition tables
When switching partition in or out, partition_ids are changing for both source and destination, even if destination is a regular table. At the beginning I thought that new id's are being issured but it appears that SQL Server simply…
Declaring table variable in SQL Server 2005
D
When there is a requirement to declare several local variables inside TSQL script, it appears that table variables must have it's own DECLARE clause. Surprisingly, Books Online do not mention that.Here you go :DECLARE @str1 varchar(8),…