Viewing 15 posts - 38,836 through 38,850 (of 49,571 total)
I'm not sure that you should be trying to rebuild indexes in the system databases.
MSDB maybe, but not the others.
May 29, 2009 at 2:17 am
endo64 (5/29/2009)
The following query always uses table scan even I create index on a, b and a+b.
Yup. Functions of any form prevent index usage
Is there a way to index a+b...
May 29, 2009 at 2:15 am
hi_abhay78 (5/28/2009)
secondly , i have had 2 cases where DBCC updateusage fixed the corruption when client moved from 2000 to 2005 ..
Update usage will fix corruption errors like this
Msg 2508,...
May 29, 2009 at 2:12 am
MCHPIS (5/28/2009)
Would you have any idea what might cause this type of thing?
As I mentioned earlier, normally this kind of thing is the result of someone doing direct edits...
May 29, 2009 at 2:09 am
WayneS (5/28/2009)
I've seen several mentions of a "catch-all" query, where the "where" statement has several conditions in it.
My definition of 'catch-all' (for what it's worth) is a query that has...
May 29, 2009 at 2:01 am
Split them out into subprocedures. The reason is parameter sniffing.
When the proc is called the first time, the entire procedure is compiled and optimised based on the values of the...
May 29, 2009 at 1:57 am
sp_change_users_login (deprecated) or ALTER USER
May 28, 2009 at 4:06 pm
It's telling you that there's a dependency entry for the procedure that references a column that does not exist in the view. (It can't be the other way around because...
May 28, 2009 at 3:28 pm
Yes, absolutely. From 2005 SQL allows you to mirror the backup files to 2 (or more) locations. They must both be the same type of device (eg both disk or...
May 28, 2009 at 2:53 pm
Bob Hovious (5/28/2009)
May 28, 2009 at 2:43 pm
Status is not, as far as I'm aware, a SQL system table. Speak to whoever developed that system.
I honestly can't see how to get 12:16 pm out of that...
May 28, 2009 at 2:15 pm
I thought I'd seen everything....
Anyone (preferably someone who's telepathic or precog) want to tackle these?
May 28, 2009 at 2:02 pm
That's not a SQL system table. Ask the developer or vendor if it's a purchased piece of software
May 28, 2009 at 2:01 pm
What time does the example value that you posted equate to? Did you get this from one of the SQL system tables?
May 28, 2009 at 1:59 pm
Viewing 15 posts - 38,836 through 38,850 (of 49,571 total)