Can You Dig It? – The Plan Cache
She can dig it!
D Sharon PruittIn this new series of posts, I plan to investigate the SQL Server plan...
2010-12-08
824 reads
She can dig it!
D Sharon PruittIn this new series of posts, I plan to investigate the SQL Server plan...
2010-12-08
824 reads
Getting SQL Server for
Christmas! Happy holidays and seasons greetings!
True to fashion, the Minnesota SQL Server User Group (PASSMN) is...
2010-12-06
348 reads
Go SQL! Go SQL! I haven’t blogged about it until now. If you weren’t aware, there’s a new conference in...
2010-12-06
371 reads
Calling for Presenters!PASS has announced the next 24 Hours of PASS and it will be on March 15 and 16. ...
2010-12-02
283 reads
Last week I suggested to others that we institute a little idea theft and put together a few blog posts...
2010-11-29
2,193 reads
Protect Your Password! As a consultant, I am frequently receiving new passwords at clients and becoming aware of the password...
2010-11-26
673 reads
Earlier this week, I suggested that we share a message of thanks on our blogs. Since I suggested we put...
2010-11-26
964 reads
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
Learning XQuery...
2010-11-24
1,599 reads
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In the...
2010-11-23
2,130 reads
Two things happened to me this morning. First, I woke up and took the written test for the SQL Server...
2010-11-22
755 reads
Setting page visibility and the active page are often overlooked last steps when publishing...
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Comments posted to this topic are about the item Password Guidance
Comments posted to this topic are about the item Using table variables in T-SQL
I am trying to check out elastic query between two test instances we have...
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers