Stranger Danger… The need for trust with constraints
I ran into an issue with errors with an database upgrade running into a violation of a foreign key constraint....
2015-08-13
419 reads
I ran into an issue with errors with an database upgrade running into a violation of a foreign key constraint....
2015-08-13
419 reads
Red Gate Documentation Update
Looks like the rapid release channel now has a great feature for locking database objects that you...
2015-08-12
277 reads
the problem of monster views
I’ve been working with tuning an application that performs a lot of Entity framework calls,...
2015-08-10
1,306 reads
Have never really played around with the option: SET NOEXEC ON
Turns out this can be a helpful way to validate...
2015-08-07
3,516 reads
out of memory, argggh!
Am I the only one that has experienced the various out of memory issues with SSMS? Not...
2015-08-11 (first published: 2015-08-05)
3,428 reads
Working in a development environment, I botched up a restore. After this restore attempt to overwrite my database with the...
2015-08-04 (first published: 2015-07-28)
3,113 reads
Was testing a batch file to add a user to a localdb instance. Assumed that my user as admin on...
2015-07-13
502 reads
Was testing a batch file to add a user to a localdb instance. Assumed that my user as admin on...
2015-07-13
317 reads
I'm excited to see the future of Sql server management studio with release of SQL Management Studio 2015 Preview. http://bit.ly/1LSu0Ek
Two...
2015-07-06 (first published: 2015-06-30)
10,634 reads
I’m excited to see the future of Sql server management studio with release of SQL Management Studio 2015 Preview. http://bit.ly/1LSu0Ek...
2015-06-30
943 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I wrote a PowerQuery that parses a table from a PDF, and I want...
Comments posted to this topic are about the item Attaching an SQL Server database...
Comments posted to this topic are about the item Superseded Indexes
Which of these indexes is superseded by another?
See possible answers