Viewing 15 posts - 5,401 through 5,415 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 3, 2015 at 1:40 pm
What's in the SQL error log?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 3, 2015 at 4:12 am
Viewing 15 posts - 5,401 through 5,415 (of 49,552 total)