Here I create a table and
inserted some duplicate records for testing purpose.
createtable temp(cust_id varchar(50))insertinto temp(cust_id)values('oms1'),('oms2'),('oms1'),('oms2'),('oms3')select*from temp
Method 1: (You can simply...
2013-03-19
3,841 reads
SQL Server 2012 brings a new feature called Indirect Checkpoint. You can read more about it here: http://msdn.microsoft.com/en-us/library/ms189573.aspx. With Indirect Checkpoint, you get smaller and too many I/Os Checkpoint...
2013-03-19
27 reads
It has been some time since I have hosted or presented on the SQL Lunch. Work and home life is...
2013-03-19
1,325 reads
Today, I’ve received an email from friend asking that that is there any way to find out the progress of...
2013-03-19
1,653 reads
I’ll be driving south a few miles tomorrow night to talk to the great group at MagicPASS about the basics...
2013-03-19
653 reads
Using SQL Server views throughout a Business Intelligence (BI) solution can provide a tremendous amount of benefits. Here is a...
2013-03-19
741 reads
I got this image in the mail recently, and it made me laugh. It looks like a police lineup, perhaps...
2013-03-22 (first published: 2013-03-19)
1,957 reads
I was recently talking with a friend about doing some research into a NAS solution for home and that I...
2013-03-22 (first published: 2013-03-19)
1,788 reads
· On April 9, 2013, Extended Support for SQL Server 2000 will come to an end, and SQL Server 2000 will...
2013-03-19
1,035 reads
This dynamic management function (DMF) returns the detailed information about low level activities on indexes such as input/output (I/O) operations,...
2013-03-19
2,898 reads
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Comments posted to this topic are about the item Admin Rights for Everyone
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
Comments posted to this topic are about the item RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers