Viewing 15 posts - 37,981 through 37,995 (of 49,571 total)
delete from ATable where TimeStamp = 'somedatetime';
what is the timestamp ... can we use this ....
Lynn was referring to whatever column it is that stored the date inserted. If you...
July 1, 2009 at 2:48 pm
Delete from SomeTable WHERE SomeDateColumn < '2000/01/01'
July 1, 2009 at 2:10 pm
blandry (7/1/2009)
I would really love to know just how true this statement is - just out of curiosity - because in...
July 1, 2009 at 2:01 pm
Let me guess, this is a database upgraded from SQL 2000?
What probably happened is that someone was messing with the system tables in SQL 2000 (where it was allowed) and...
July 1, 2009 at 1:49 pm
Writing 2TB of zeros will take a while. That's exactly what instant file initialisation was added to prevent - the need to first write over the data file with zeros...
July 1, 2009 at 1:14 pm
Bhargav Patel (7/1/2009)
CTE really improves performance as always in most cases.
Got some examples of that?
CTEs are pretty much 'named subqueries'. The whole query still runs in one go just...
July 1, 2009 at 12:22 pm
This is one reason why columns should always be prefixed with the name or alias of the table they're from. It's just good practice and, if you do that, putting...
July 1, 2009 at 12:16 pm
I assume you mean multiple TempDB files, seeing as there can only be one TempDB database.
I would start with 4 files for TempDB, all on the same drive. Placing any...
July 1, 2009 at 12:12 pm
Please in future start a new thread for a new question.
Placing the mdf file on one drive and the ldf on a separate drive will give you IO benefits as...
July 1, 2009 at 12:07 pm
Krasavita (7/1/2009)
Thank you it make sense,just make sure I understand corectly: Is for data and logs the same?
The recommendations are the same. Whether or not you set the growth to...
July 1, 2009 at 11:13 am
It's not a bug. You're allowed to reference columns from the outer query inside a subquery. It has to be allowed, or something like this couldn't be done
select * from...
July 1, 2009 at 11:08 am
It's not about security. Checksum page protection lets SQL pick up more forms of corruption than Torn page could, and also can show that said corruption is caused outside of...
July 1, 2009 at 10:54 am
Odd. I can't see why that should be happening.
This seems to work, though I'm not sure why it does and the other version doesn't.
EXEC master..sp_MSForeachdb '
IF DB_ID(''?'') > 4
BEGIN
EXEC (''Alter...
July 1, 2009 at 10:27 am
There are no hard and fast rules for this. We can't say that your config is right or wrong.
Recommended practices:
Monitor the size of the DB and manually grow it...
July 1, 2009 at 10:19 am
david.morrison (7/1/2009)
sorry IE had a freak out when posting. I tried to delete but didnt work
Threads can't be deleted. No worries.
July 1, 2009 at 9:55 am
Viewing 15 posts - 37,981 through 37,995 (of 49,571 total)