I just think its great you took time to write the article and help out, and get people thinking of ways to make their jobs easier. I worked with...

Please don't misunderstand me, I did not mean to imply CURSORs are bad. I used to use them all the time (yes in SQL 6.5,7.0, 8.0 & 9.0, less...

That was my final solution, though varchar (or nvarchar) (max) is another SQL feature I hesitate to use, though in this situation it is benign and a good solution.

In my case, with your solution of packing it all into a variable, my list was truncated because of the limited space. I will try it with a larger...

Something like this for example:

DECLARE @query table (num int, dSQL varchar(2000))

DECLARE @dsql varchar(2000)

DECLARE @RoleName sysname = 'LoneWolfDBA'

DECLARE @cnt int = 0

INSERT @query (num,dSQL)

SELECT row_number() over (order by ROUTINE_SCHEMA,...

Elliott Whitlow (5/12/2012)

---

As a further point, I dislike most aspects of technical interviews purely because in MANY cases they are very subjective and if you don't give them the answer...

I am curious why no one has stated the obvious, if you are a Senior DBA you have a script that will take any database name and file path and...

But with a script you can test it and retest it so when it has to work you...

I think not respecting a DBA that uses the GUI is an old DBA thing. In SQL 6.5 and to a lesser degree 7.0 (and earlier) the GUI was...

If a DBA works for a single organization for many years and never works outside that organization then they will only have the tools that are required by that job....

If you have the option to do some redesign of the application you might want to try something like:

Reading from your Inventory table, but updating your InventoryUpdate View that uses...

Vijay,

Is this an online store scenario, where you have a product catalog and need to keep track of orders or something of that nature?

It is my understanding that the mirrored database is for failover only and is not viewable in anyway. Is this what you need from your replicated databases?