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

2002-05-28

659 reads

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

2002-05-13

585 reads

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)

2002-05-06

1,881 reads

Blogs

Upgrading SQL Server 2017 Containers to 2019 non-root Containers with Data Volumes – Another Method

By

Yesterday in this post I described a method to correct permissions when upgrading a...

Power Platform Quick Tips – Episode 02: Dynamic Power Apps Form Headers

By

Welcome back to my Power Platform Quick Tips series! In this second episode we...

Simple-Talk Article…Understanding Azure Storage Options

By

Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Salesforce as linked server and replication on local database

By crazyfrog

Hi, What to achieve (it is complicated to explain) : Set up a local...

The CTE Insert

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The CTE Insert

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The CTE Insert

See possible answers