Here is a modified SP_WHO procedurewhich returns more information about the current session.I forgot all the thing that i have added to the sproc, but the last addition shows the last executed TSQL statement.There might be a better solution to get the values from DBCC rowset, thou I did not have time to think everything […]
2002-05-28
717 reads
Procedure that net sends a message to any user who logged in as SA.IN. had to use this once in the company where SA password was blank for a while and managment did not want to set a password on the account. You can also set it to work with any username or for users […]
2002-05-14
883 reads
Here is handy procedure to generate random number.I find it useful when I generate large amount of test data in a database.For example if you need to create a Customer Data and what they have purchased in the last month to run perfrmance tests on large amount of data an set up necessary indexes.You can […]
2002-05-13
695 reads
Here is as sample of implementing cursor.In some cases my tests showed that this approach performs better than native cursors in SQL Server.All you have to do is move the dataset into a temp table with a new Identity column and then use a simple loop to extract the data as you would do normally […]
2002-05-06
1,985 reads
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
By John
One of the more frustrating aspects about creating an Azure virtual machine is that...
By Steve Jones
Redgate Monitor has been able to monitor replication for a long term, but it...
I've come across what appears to be a strange deadlock anomaly. As seen in...
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Comments posted to this topic are about the item The Challenge of AI, which...
From T-SQL, without requiring an XEvent session, can I tell which deprecated features are being used on my instance?
See possible answers