SQL Server Code,Tips and Tricks, Performance Tuning
A blog about SQL Server, Books, Movies and life in general
Showing posts with label
Performance
.
Show all posts
Showing posts with label
Performance
.
Show all posts
Thursday, October 05, 2017
Data types storage differences
›
It has been a while since I wrote some of my best practices posts. I decided to revisit these posts again to see if anything has changed, I...
1 comment:
Friday, November 04, 2016
Are your foreign keys indexed? If not, you might have problems
›
When you add a primary key constraint to a table in SQL Server, an index will be created automatically. When you add a foreign key const...
Sunday, December 16, 2007
EXISTS or COUNT(*)
›
Do you use this IF ( SELECT COUNT (*) FROM SomeTable WHERE SomeColumn = SomeValue ) > 0 Or do you use this IF EXISTS ( SELECT * FRO...
Monday, October 15, 2007
Interview With Kalen Delaney About Inside Microsoft SQL Server 2005 Query Tuning and Optimization
›
I am a big fan of Inside Microsoft SQL Server 2005 The Storage Engine so when I saw that yet another book got published in this series I ju...
Wednesday, May 30, 2007
Speed Up Performance And Slash Your Table Size By 90% By Using Bitwise Logic
›
You have all seen websites where you can pick a bunch of categories by selection a bunch of check boxes. usually what you do is store those ...
1 comment:
›
Home
View web version
