SQL Server Code,Tips and Tricks, Performance Tuning
A blog about SQL Server, Books, Movies and life in general
Showing posts with label
Code
.
Show all posts
Showing posts with label
Code
.
Show all posts
Tuesday, February 12, 2019
Using SonarQube, SonarQube Scanner and the sonar-tsql-plugin to run static code analysis
›
In the previous post Scripting out procs and user defined functions with PowerShell , we scripted out some procs and functions from the Adve...
Monday, May 14, 2007
Make Your Case Sensitive Searches 1000 Times Faster
›
I had an case sensitive update query that ran in about 9 minutes. Since it was a case sensitive query it did an index scan not an index seek...
4 comments:
Tuesday, April 10, 2007
Script Multiple Procs With Create And Drop Statements In SQL Server 2005
›
In SQL Server 2005 Management studio you can not script out multiple procedures with a create and drop statement This is what you have to do...
3 comments:
Wednesday, March 14, 2007
How To Get The Database Name For The Current User Process
›
This question pops up frequent enough so here are 4 ways to return the database name for the current user process First up is the fastest me...
1 comment:
›
Home
View web version
