Viewing 15 posts - 40,006 through 40,020 (of 49,571 total)
rubes (4/3/2009)
Thanks for the input Gail. Checksums are enabled and have been for quite a while.
Odd, because there's references to torn pages. It means that not all the...
April 3, 2009 at 3:15 pm
Torres (4/3/2009)
The udf is a Table-valued Function, returning a dataset.
Multistatement or inline?
April 3, 2009 at 2:57 pm
Torres (4/3/2009)
Hello.When joining a table with a udf, does the Server process the udf query independently, or does it consider the joins and any where conditions?
Depends. If it's a multi-statement...
April 3, 2009 at 1:48 pm
Paul TriVegg (4/3/2009)
April 3, 2009 at 1:35 pm
Thang.Nguyen10 (4/3/2009)
April 3, 2009 at 1:25 pm
In 99% of cases, corruption (especially recurring corruption) is a result of a problem with the IO subsystem. It may be faulty drivers, it may be faulty SAN controllers, it...
April 3, 2009 at 12:40 pm
J-F Bergeron (4/3/2009)
April 3, 2009 at 12:28 pm
Gaby Abed (4/3/2009)
BTW, Congrats Gail on your new MVP status.
Thanks, but it's not particularly new. I was awarded last year July. (http://www.sqlservercentral.com/articles/SQLServerCentral/63590/)
Grant's the new kid on the block this month...
April 3, 2009 at 12:27 pm
Christopher Stobbs (4/3/2009)
WHERE
/*
isnull(FIRSTNAME,'') like '%%'
AND isnull(MIDDLEINITIAL,'') like '%%'
AND isnull(LASTNAME,'') like '%%'
AND isnull(EMAIL,'') like '%%'
*/
This can't be removed, at least until we know why it's there in...
April 3, 2009 at 11:25 am
josephptran2002 (4/3/2009)
April 3, 2009 at 8:59 am
Strange. No stack dumps? (.mdmp files in the SQL log directory)
What happens if you run a full checkDB rather than the individual check tables?
DBCC CHECKDB (< Database Name > )...
April 3, 2009 at 8:57 am
josephptran2002 (4/3/2009)
Some people in here, they are here to show off and intimidate new developer. Not try to help them out and misguide others to different issues.
Want to name...
April 3, 2009 at 8:56 am
Looking at the nicely cleaned up version posted by Chris (Thanks Doc) part of your problem is fairly easily apparent.
You have a cross join in there. The users and the...
April 3, 2009 at 8:22 am
What changed 4 days ago? This kind of thing doesn't just happen, something changed.
What you're probably going to have to do is find the worst performing queries and tune them....
April 3, 2009 at 7:45 am
Is it blocked by some other process?
Can you post table definitions, index definitions, aprox row counts and the execution plan, saved as a .sqlplan file, zipped and attached?
April 3, 2009 at 7:42 am
Viewing 15 posts - 40,006 through 40,020 (of 49,571 total)