Viewing 15 posts - 40,486 through 40,500 (of 49,571 total)
raj acharya (3/9/2009)
so can u pls help out...
March 9, 2009 at 9:53 am
An hour just to do a count(*) of a table?
Got indexes on the srcflag columns?
March 9, 2009 at 9:39 am
Jose Ianuck (3/9/2009)
so what impact does a database snapshot have on application transaction throughput and performance?
Depends on your app, your hardware and the DB's usage. Could be anything from no...
March 9, 2009 at 9:38 am
danielthompson (3/9/2009)
Should I be pushing for the company to migrate the production systems to SQL Server 2008?
That depends on whether or not you need any of the 2008...
March 9, 2009 at 9:36 am
GSquared (3/9/2009)
Stored procedures and other code objects are, to my knowledge, always in the Primary filegroup.
Yup. They're stored in the system tables and the system tables are always in PRIMARY.
March 9, 2009 at 9:29 am
Post the code please?
My guess is you're referencing the cursor after it's deallocated.
March 9, 2009 at 1:11 am
thieuquanghuy (3/8/2009)
FOR LOGIN_EVENTS
The only thing that trigger is going to catch are the CREATE LOGIN, ALTER LOGIN and DROP LOGIN statements.
March 8, 2009 at 2:05 pm
Perry Whittle (3/8/2009)
March 8, 2009 at 1:59 pm
Paul Randal (3/8/2009)
If you don't know the name of the executable, how can you do resource balancing on a machine with multiple instances - e.g. using WSRM?
You look it up...
March 8, 2009 at 1:33 pm
Dean Cochrane (3/8/2009)
The correct solution to your problem is not to beat SQL Server into tortured subservience, it is to rewrite the bad code into good code.
😎 May I steal...
March 8, 2009 at 1:06 pm
Bob Hovious (3/8/2009)
Gail, do they have the "Inspector Gadget" cartoon over there? I find that tune flushes everything else out.
I've seen it, long, long ago. Can't recall...
March 8, 2009 at 1:04 pm
Perry Whittle (3/8/2009)
also depends on if they mean client or server side. Server process is sqlservr.exe
Server or client, how important is it really for a candidate to know that? Seriously,...
March 8, 2009 at 11:40 am
Paul Randal (3/7/2009)
So far the most popular answer is that backups are never validated :crazy:
At least they have backups.
March 8, 2009 at 11:33 am
Viewing 15 posts - 40,486 through 40,500 (of 49,571 total)