Viewing 15 posts - 40,531 through 40,545 (of 49,571 total)
IF.. ELSE is a control flow statement that affects what statements are run. It can't be used inside a SQL statement. With a SQL statement, use CASE.
So, I would use...
March 6, 2009 at 8:31 am
ALZDBA (3/6/2009)
Nowadays, 500MB isn't that huge, but if OP needs to keep his drive space and this is a yearly event, I wouldn't mind shrinking.
I wouldn't either, as a once-off...
March 6, 2009 at 8:12 am
Shamshad Ali (3/6/2009)
what would you suggest now?
That you ask the DBA who recommended that why he recommends such a low fill factor.
The main reason for something like that...
March 6, 2009 at 3:04 am
Take a look at this article. There's a section on these catalog errors. http://www.sqlservercentral.com/articles/65804/
Bad news, the fix is not easy.
March 6, 2009 at 3:01 am
t.walker (3/5/2009)
So why do you respond to people who can't be bothered with the basics!!
Personally, because I'm eternally hopeful that perhaps they will learn and improve themselves. Sure, only a...
March 6, 2009 at 2:49 am
Shaun McGuile (3/6/2009)
UK min Holidays is 20 working days
South Africa is minimum 15 working days (3 weeks), generally increasing as a person is promoted (I had 24 at my last...
March 6, 2009 at 2:47 am
Jeff Moden (3/5/2009)
March 6, 2009 at 2:34 am
matt stockham (3/5/2009)
March 5, 2009 at 3:05 pm
Marios Philippopoulos (3/5/2009)
where do the scans reported on the OID-based indexes originate from, if not from join operations...
OID?
If you're talking about a scan on a table involved in a join...
March 5, 2009 at 3:02 pm
Perry Whittle (3/5/2009)
i was under the impression that a database backup in simple recovery mode also initiates a checkpoint which will truncate the log file
Might do. Did something I said...
March 5, 2009 at 2:52 pm
jcrawf02 (3/5/2009)
GSquared (3/5/2009)
March 5, 2009 at 2:51 pm
Marios Philippopoulos (3/5/2009)
Doesn't that involve an index scan?
Not with good indexes. Single row index seeks or a full index scan or seeks on some other criteria followed by a...
March 5, 2009 at 2:12 pm
Bruce W Cassidy (3/5/2009)
But I don't see any advantage for using the date over an ID field, so I still tend to use an ID field.
There is if...
March 5, 2009 at 2:08 pm
Bruce W Cassidy (3/5/2009)
March 5, 2009 at 1:59 pm
Marios Philippopoulos (3/5/2009)
What is this about a uniquifier, can you pls elaborate?
http://sqlinthewild.co.za/index.php/2009/02/09/all-indexes-are-unique/
March 5, 2009 at 1:53 pm
Viewing 15 posts - 40,531 through 40,545 (of 49,571 total)