Technical Article

Modified SP_who

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 […]

You rated this post out of 5. Change rating

2002-05-28

707 reads

Technical Article

Procedure for Random Numbers

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 […]

You rated this post out of 5. Change rating

2002-05-13

661 reads

Technical Article

Cursorless Cursor

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 […]

4.5 (2)

You rated this post out of 5. Change rating

2002-05-06

1,968 reads

Blogs

Updating SSMS is Easy (w/ v21)

By

I’ve been using the SSMS preview for v21. This is the next evolution of...

Master SQL Server Query Tuning in Just Two Days! Online Live Training – June 17 – 18, 2025

By

I’m excited to announce that on June 17 – 18, 2025, I’ll be running...

How To Restore Change Data Capture – CDC Tables When Restoring a SQL Server Database

By

I have recently had the privilege of working with multiple clients who have been...

Read the latest Blogs

Forums

Third party backup softwares

By ashrukpm

Hi Team, Can you someone suggest a few good third part backup tools, with...

2022 SSIS PackageFormatVersion?

By TG

Recently I upgraded my ssis package from 2016 to 2022, but package format version...

Meta AI by Facebook: A New Contender in the AI Battle

By Daniel Calbimonte

Comments posted to this topic are about the item Meta AI by Facebook: A...

Visit the forum

Question of the Day

The Monitor Server

What does the monitor server do in log shipping?

See possible answers