The query to extract the plan cache fails when there is an offline database on the server.

There's a saying:

"Don't blame the tool, blame the fool behind the tool".

My years of systems development really comes in handy. Whenever I need to do something, my first thought is " automate". Next is how do I replicate this procedure(s).

CMS helps...

I never really thought about it that way, but it is so true.

Being a DBA can sometimes be outright boring and that's why I still do programming on top...

I find the biggest constraints to be time and available hardware. One would also need a sample database(s) just to speed things up.

Replication, Failover technologies and disaster recovery all needs...

For me, it must be lack of proper design.

A program, database, network all need a proper design.

Whatever happened to "back to the drawing board", and I mean a real drawing...

This may help.

http://www.sqlservercentral.com/articles/Memory/74867/

Just do another restore with the "Move file" option. Alternatively you can do a restore from any other DB backup, just to get the database back to a usable state...

This is basicaly the concatenation of strings (like a sum for numeric).

An alternative could be:

declare @tblNames table([Name] varchar(100))

insert @tblNames values ('Lucian')

insert @tblNames values ('Terry')

insert @tblNames values ('Jane')

select SUBSTRING((SELECT ',' +...

I have script that generate DML stored procs for all tables. This will help me generate even more code, if only the C# script is available. Please fix the link

bhovious (8/25/2008)

---

Hey lucian

Here is some code for doing parsing using a tally table. We usually have a pre-generated one in each db, but this code will run...

bhovious (8/22/2008)

---

My existing parser function uses a tally table like that last example and runs pretty damn quick. The huge CPU performance difference I saw was in...

WayneS (8/22/2008)

---

I agree. And that's a pretty interesting...

For what it's worth try this method.

--Create a Tally table. Just a table that hold a big number of integer numbers (100000 in this case)

use AdventureWorks

DECLARE @StartTime DATETIME ...

WayneS (8/21/2008)

---

lucian (8/21/2008)

---

Very useful.

I use it to process a comma delimited list of keys or any other list of values that is passed as a parameter to a stored proc.

Now...