Retrieve unsaved query
I was working on a remote machine and while I was away, the machine was restarted. Lost the scripts I...
2013-03-20
122 reads
Consuming News Through Social Media and Read It Later With Pocket
These days the fastest way, not always the most accurate, to get news is through social media. Technology, sports, politics,...
2013-03-20
1,095 reads
Remove duplicate records from a table in SQL server
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: Indirect Checkpoint (Target Recovery Time), get the real scoop
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
SQL Lunch – Power View Against Multidimensional Models
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
SQL Server DMV: sys.dm_exec_requests
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
Speaking Tomorrow Night at MagicPASS
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
Benefits of using views in a BI solution
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
It’s a Lineup at SQL Intersection
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
Learning By Doing
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
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers