WOuld it be possible to post the 'explicit' grants mentioned for creating the user defined role please ... I've been looking for something like this for some time - just...

Not so on the permissions thing. I have a number of SQL Servers registered under a normal domain user account - which cannot start/stop the SQL Services (I use a...

The secret(s) are:

• enjoying what your doing (your trade/profession/job/roles)
• enjoyiong where you do it (where you work and who you work with)
• where you do it they enjoy you (your peers and bosses)

If you...

The easy way is to build the new cluster along side the existing cluster (with totally new names of course). Then after things have been switched (short for moving all...

As far as I know the 'dt' stored procedures are used with the SQL diagramming tool (hence 'dt'). They first apepared in v7.0. The procedures are created 'auto-magically' when you...

It's been a long week (that started last Monday :rolleyes a few late nighters , a few all...

Here's another good link:

http://www.connectionstrings.com/

Locks only keep honest people out !

For issues of 'alias-ing' tables in a query, one should have a 'site standard' <period>. Clarity and maintainabilty are the secondary goals in the composition of SQL (and stored procedures)....

To avoid any possible network traffic issues I always monitor directly from the SQL Server and store the files locally. PerMon generates a substantial amount of data through the wire...

If you are using 'connection pooling' then this is probably not possible. If you are not using connection pooling, then it's time to change the application or look at another...

SET WORSHIP_BILL_GATES_MODE OFF

GO

I realize that this is a MS/SQL Server site but it seems that yours volumes are approaching the scalability/reasonability limits of the present SQL Server.  I've worked with Sybase...

You may also want to pose the sp_spaceused results for each table in the query as well. The collective may be able to optimize your query, but let's face it,...

RAM and CPU by database ? hmmm ... sounds interesting ... but one has to realize that those are global resources shared by all of the user and system spids...

You might want to perform a few 'due diligence' things (even though your deletion worked).

• recycle your SQL Server (yes reboot it)
• look for *.DMP files
• look for exception files
• the dump and exception files...