Final December Giveaway!
Today I'm giving away the book Professional SQL Server 2012 Internals and Troubleshooting. If you live outside the continental US,...
2013-12-30
509 reads
Day 5 – Peer Identity
This is the fifth installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...
2013-12-29
7 reads
Day 5 – Peer Identity
This is the fifth installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...
2013-12-29
718 reads
Deleting Duplicate rows using CTE
Many times we caught in a situation where we have a table where there is no primary or unique column...
2013-12-29
59,409 reads
Day 4 – Broken Broker
This is the fourth installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...
2013-12-28
25 reads
Day 4 – Broken Broker
This is the fourth installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...
2013-12-28
725 reads
Answer -Question of the Week - 25/12/2013- Question 1
Question:- Suppose we have a table says tbl_students whose structure is given below:-
Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150))
Suppose it...
2013-12-28
775 reads
Question of the Week - 28/12/2013 - Question 2
Question:- Suppose we have a table named tbl_charactername have only one column say "charactername".It contains 10 rows. First 5 rows...
2013-12-28
539 reads
The Effective Cell Phone
I’ve written a bit about phones recently as I’ve experienced the switch back to iOS from Android. There are a...
2013-12-27
858 reads
Reblog: December 20 to December 26
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-12-27
779 reads
Blogs
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers