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
130 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,097 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,844 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
32 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,327 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,683 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
655 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,792 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Designing for Teams
Comments posted to this topic are about the item Designing for Teams
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers