Viewing 15 posts - 61 through 75 (of 94 total)
Oops! I posted to both! I thought that they were the same post and assumed that I accidentally closed the window the first time without posting.
Greg
February 9, 2009 at 2:46 pm
I would use NOT EXISTS instead of NOT IN for better performance like this:
SELECT DISTINCT a.InvoiceID
FROM TestTable a
WHERE NOT EXISTS
(SELECT * FROM TestTable b
WHERE...
February 9, 2009 at 2:42 pm
I would use NOT EXISTS instead of NOT IN like this:
SELECT DISTINCT a.InvoiceID
FROM TestTable a
WHERE NOT EXISTS
(SELECT * FROM TestTable b
WHERE a.InvoiceID = b.InvoiceID...
February 9, 2009 at 2:34 pm
Try this:
SELECT CONVERT(VARCHAR, GetDate(), 101) + ' ' +
CONVERT(VARCHAR, DATEPART(hh, GetDate())) + ':' +
RIGHT('0' + CONVERT(VARCHAR, DATEPART(mi, GetDate())), 2) AS Date
Greg
February 9, 2009 at 2:03 pm
February 9, 2009 at 8:22 am
SQL won't sort it that way by default because '{{{' comes before 'www' alphabetically. You could sort by ASCII code like you suggest, although I can't guarantee that it...
February 6, 2009 at 1:02 pm
When ordering a string, it uses alphabetical order.
NULLs are the lowest value,
then special characters,
then numbers,
then letters.
Greg
February 6, 2009 at 12:24 pm
In a typical disaster (Is there such a thing as a typical disaster?) you would rename the new server the same as the old server, so that you wouldn't have...
February 6, 2009 at 8:49 am
Assuming that you are testing the database after restore, then yes, you should feel pretty comfortable. At the last company that I was at, we did full disaster recovery...
February 4, 2009 at 12:39 pm
I don't think you need to simulate a hardware failure. You just need to simulate your restore process. That could be just restoring the database from backup or...
February 4, 2009 at 12:22 pm
February 4, 2009 at 12:05 pm
It sounds like you're talking about two different things. Like GSquared said, truncating occurs automatically after you backup the log file. Shrinking the size of the log file...
February 4, 2009 at 11:45 am
It's much better to look for a job when you already have one, than when you're unemployed. It allows you to be much more selective and find the best...
February 4, 2009 at 8:12 am
I used to work at an insurance company and we had a similar requirement. We used two columns, an effective date and an end date. So when querying,...
February 3, 2009 at 12:24 pm
I reread your post above. Sounds like a rather strange requirement. I'm not sure why you wouldn't just want everything that is a month older. That would...
February 3, 2009 at 7:58 am
Viewing 15 posts - 61 through 75 (of 94 total)