Viewing 15 posts - 4,201 through 4,215 (of 8,416 total)
I think I was misled by a combination of the Related Articles links on the page (the top one takes you to the Editorial Review for the book), the link...
April 5, 2010 at 10:10 am
One safe way is:
SELECT TT.RunId,
CONVERT(DATETIME, TT.Value, 103)
FROM tmp_TestTable TT
WHERE TT.Value IS NOT NULL
AND ...
April 5, 2010 at 9:53 am
Steve Jones - Editor (4/5/2010)
April 5, 2010 at 9:27 am
No worries. Good luck 🙂
April 5, 2010 at 9:06 am
SQL Server does not guarantee how many times an expression will be evaluated, or in which order...so long as the returned results logically reflect the request in the query.
In this...
April 5, 2010 at 8:42 am
CirquedeSQLeil (4/5/2010)
Paul White NZ (4/5/2010)
Public Holiday 🙂Back to Back holidays or just Easter?
Just Easter...
April 5, 2010 at 8:34 am
Bill Nicolich (4/5/2010)
...when that happens, there's the problem of identifying rows that have been marked as reserved but are not being handled by a current user.
A history table works well....
April 5, 2010 at 8:24 am
GSquared (4/5/2010)
Considering that that bug has already been fixed, I'm not too worried about it.
Did you miss the (multiple) smileys, Gus?
Humour.
April 5, 2010 at 8:19 am
MAK-1128556 (4/5/2010)
do you have any sample scrip to compress the active log
The log file (normally *.LDF) is a SQL Server file and cannot be compressed by SQL Server 2005. ...
April 5, 2010 at 8:17 am
TheSQLGuru (4/5/2010)
April 5, 2010 at 8:04 am
MAK-1128556 (4/5/2010)
I try to compress the log file but it is not copressing because database is in FULL mode
You can't compress the active log file (unless you are using SQL...
April 5, 2010 at 7:59 am
Frank-461314 (4/5/2010)
The table has 250 weeks and growing. I want to create a filegroup/week so it would be easy to maintain and move the filegroups around the disk system.
Bear...
April 5, 2010 at 7:54 am
1. Only rebuild or reorganize indexes that absolutely require it
2. Spread the bare-minimum of rebuilds and reorganizations out over time
3. Compress the log backups before shipping them across the link
4....
April 5, 2010 at 7:37 am
dbowlin (4/5/2010)
Paul White NZ (4/1/2010)
If there are points available for being obscure...
SELECT {fn CURRENT_DATE()};
This clearly wins the simplicity contest. I have not seen this one before, thanks.
No worries...
April 5, 2010 at 7:16 am
Viewing 15 posts - 4,201 through 4,215 (of 8,416 total)