Here is a great movie which was made for Israel Users Group 100 anniversary. All singers are SQl Server DBAs :-)https://vimeo.com/14748423Enjoy!
"Select Star" - Israel DBAs singing for SQL Server UsersGroup meeting 100
"
I play in Conduit promo movie :-)
I
This movie was made for Conduit 5 years event: http://www.youtube.com/watch?v=1M_GNUUvQfE.
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…