|
|
|
|
Browse by Tags
All Tags » Tools (RSS)
Showing page 1 of 3 (21 total posts)
-
Mladen Prajdić just released SSMS Tools PACK 1.0. SSMS Tools PACK is an Add-In (Add-On) for Microsoft SQL Server Management Studio and Microsoft SQL Server Management Studio Express.
Here are some of the features
Uppercase/Lowercase keywords.Run one script on multiple databases.Copy execution plan bitmaps to clipboard.Search Results in Grid Mode ...
-
This download is the January 2008 release of SQL Server 2005 Best Practices Analyzer.
Get it here: http://www.microsoft.com/downloads/details.aspx?FamilyId=DA0531E4-E94C-4991-82FA-F0E3FBD05E63&displaylang=en
-
SQLCLRProject is an alternative to the built-in support in VS for deploying SQLCLR objects. Check it out at:
http://nielsb.wordpress.com/sqlclrproject/
-
(See my part 1 article about non-trusted constraints in general: http://sqlblog.com/blogs/tibor_karaszi/archive/2008/01/12/non-trusted-constraints.aspx)
The optimizer is a pretty smart little animal. It can even use constraints to eliminate some data access or part of a query. That assumes however that the constraint is trusted. For example, for ...
-
When an issue comes up more than once in a short period of time, I figure it is a message from the Universe. I might even assume it is a gift of blog fodder. So I won't turn down the gift, even if it means another juicy post before the end of year, much to Denis' disappointment.
The issue is SQL Server 2005 ''Included Columns''. There was a post ...
-
Have you ever needed to find your most expensive queries and quickly grew weary of writing T-SQL against trace tables to try to ferret them out? Have you ever had to wade through gigabytes of trace data just to find one ill-behaving query? Have you ever struggled to decide what performance metrics really matter when analyzing Profiler ...
-
I first heard about the possibility of database cloning way back in version 7.0 and thought it sounded like a great idea. Who wouldn't love to have a bunch of identical little databases running around, of smaller size and easier manageability?
Cloning a database means creating a statistics only copy of it, so that you can examine ...
-
Last July, I posted about a way to run a batch multiple times when you use GO as the batch separator. I usually take advantage of this technique when I am loading test data into a table.
I was mentioning this feature to my class last week in Minneapolis, and one of the students thought that this feature had another use. He thought it ...
-
At first I thought I would just add another sentence to my previous post, but then I realized that this feature is not even documented anywhere, and it might be useful to mention it in its very own post. I have no idea why it is undocumented, but it has been part of all command interfaces to TSQL that I have used for the last 20 ...
-
At least, I think it might become my new favorite tool. J
One of my readers created a tool to graphically display database storage internals, like allocation information, actual page contents, etc. This is just the tool I would have wanted to write if I ever got back to doing any programming. Here's what the author, Danny ...
1
|
|
|
|
|