Why am I getting a primary/unique key violation?
This may seem like a question with a simple answer but there is a bit more to it than you...
2014-07-23
1,315 reads
This may seem like a question with a simple answer but there is a bit more to it than you...
2014-07-23
1,315 reads
I seem to get a lot of permissions questions these days and one of the more frequent ones goes along...
2014-07-28 (first published: 2014-07-21)
8,651 reads
When I was in college and taking programming classes (back in the days when “a T-Rex ate my 5.25 inch...
2014-07-22 (first published: 2014-07-16)
9,125 reads
Let’s start by assuming that ANSI_NULLS are ON. If you aren’t sure what ANSI_NULLS are exactly, don’t worry, I’ll be...
2014-07-15 (first published: 2014-07-14)
10,879 reads
If you want to grant a user the ability to create/alter/delete any table, SP, function etc in a database you...
2014-07-10
957 reads
I assume that since it’s the second Tuesday of the month that it’s time for T-SQL Tuesday. And you can...
2014-07-08
827 reads
Early yesterday Kirsten Benzel(b/t) announced something very exciting, at least exciting to me. Argenis Fernandez(b/t) has agreed to wear a...
2014-07-02
689 reads
One of the most powerful tools we have as users of SQL Server is Books Online (BOL). Whether you work...
2014-06-30
3,854 reads
Every now and again you have to put a really long string (more than 8000 characters). Dynamic SQL is the...
2014-06-25
1,757 reads
These are a couple of stored procedures I wrote to help me with security research. Each of the stored procedures...
2014-06-23
683 reads
By HeyMo0sh
Test Data Management (TDM) is essential in software development to ensure your application runs...
By Rohit Garg
Introduction Full-Text Search in SQL Server is a feature that provides linguistic search capabilities...
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday. As a start,...
Hi Replication and publisher configured on the same sql server 2022 version. Subscription to...
Hello, I am trying to firgure out how to merge duplicate indexes using a...
Dears, I was told that I cannot access delta files in SQL Server Managed...
If I want to enable a trace flag for a specific query, how do I do it?
See possible answers