Me again...

Just wanted to be clear that I'm not against Red Gate's products. Rather, I like them.

But I've seen Development groups get too excited about buying new, cool-looking software...

Terry,

I think you're doing your company a favor by having a solid process in place. Adding additional software into your process often requires your process to change without significant benefits...

Good insight behind the scenes, Andy.

One of our customers has reported performance problems in the app. A trace revealed these "statman" selects were taking 20 seconds or more to complete....

I guessed based on the order in which SQL Server would encounter the errors. The first issue encountered by SQL Server is exclusive use of the database being restored. This...

Yes, views are static.

So here's an alternative:

You can dynamically create the view based on whenever the ServerName changes in your table:  (I actually use this technique often.)

Create a stored...

What's the schema of the GENRE_PARENT table?  ...There are references to gp.PARENT_GENRE and gp.PARENT_ID. Is there more logic after the last "AND" but before "ORDER BY"?

Regardless, try putting gp.Parent_ID or...

You could use the newid() system function as in:

select newid() [RowId], * from MyTable

The newid() function returns a value of the uniqueidentifier datatype. The uniqueidentifier is a large (16 bytes)...

Another option may be to create multiple stored procedures (perhaps using the "sprocName;#" syntax) and call a different one for each set of parameters that generate a different plan. For...

Great article.

My collection of VBScipt and batch files has grown over the years as I automate the many tasks that I am responsible for. I've tried designing full-blown applications to handle...

Normalized? No. Normalization will be part of the db overhaul. Good insight... I thought you were looking over my shoulder. (What color shirt am I wearing?)

But even for our normalized...