Viewing 15 posts - 5,401 through 5,415 (of 49,571 total)
Shrinking fragments indexes. When he shrank the DB, he would have re-fragmented every single index.
Shrinking is NOT a maintenance task. It should only be done after there has been some...
July 6, 2015 at 5:54 am
The index that's being complained about has as key columns (BIGINT, INT (or SMALLINT, TINYINT or BIT), DATE INT, INT). Double check the server, database, everything. It's not that uncommon...
July 5, 2015 at 8:55 am
Paulo A. Nascimento (7/5/2015)
you cannot generate for free such secure and bold opinions
Actually, I can.
Because I know how SQL works and because I've seen people try this before. Because...
July 5, 2015 at 8:51 am
No, you won't get an entry in the SQL error log. A timeout is a client-side error, it's the client deciding that it's waited too long for a query to...
July 5, 2015 at 8:23 am
Are you sure you're checking the correct database? The index mentioned in the error has 5 key columns, the only you posted the definition of only has 1. They're definitely...
July 5, 2015 at 8:20 am
That's not, in general, a very safe thing to do. You have no idea how long the session that you're killing has been running, you have no idea how important...
July 4, 2015 at 1:59 pm
manisingh2802 (7/3/2015)
The transaction log for database 'AspenBatch' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc...
July 3, 2015 at 1:40 pm
What's in the SQL error log?
July 3, 2015 at 10:42 am
The database containing the indexes which you are rebuilding. If you specify the SORT_IN_TEMPDB option, then TempDB as well.
July 3, 2015 at 7:46 am
Your DBA is right. You're doing index rebuilds, they require a lot of free space in the data file and a lot of space in the log file. If you...
July 3, 2015 at 7:14 am
Koen Verbeeck (7/3/2015)
BL0B_EATER (7/3/2015)
Koen Verbeeck (7/3/2015)
Grant Fritchey (7/3/2015)
That reminds me of the old dot com days. It was expected that everyone was going to work like pigs, nights & weekends....
July 3, 2015 at 6:31 am
Mark Dalley (7/3/2015)
How do the sizes of a database, the size of tempdb, and the sizes of their respective logs, interact?
They don't really.
A user database's size is based...
July 3, 2015 at 5:55 am
The choice isn't about performance. CONVERT allows you to specify the format code for the date, CAST doesn't.
July 3, 2015 at 5:28 am
TomThomson (7/3/2015)
But don't make the mistake of thinking that all-nighters are always a sign of problems, or long hours (how can long hours be "heroic"?).
No, I'm not talking about...
July 3, 2015 at 5:27 am
gkramer 23701 (7/3/2015)
One of our developers just steped into our office and asked why it is not possible to create a Foreign key to a Unique constraint ??
It is possible....
July 3, 2015 at 4:12 am
Viewing 15 posts - 5,401 through 5,415 (of 49,571 total)