Viewing 15 posts - 8,491 through 8,505 (of 49,552 total)
The full, the latest diff, all the logs since that diff. The fact that earlier diffs are corrupt is irrelevant.
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 10, 2014 at 2:21 am
Yes, but that's fine. That's why I said ignore the execution times of the first run (the one that loads the data into memory). After that, the times are consistent...
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 10, 2014 at 12:58 am
Don't ever append backups to the same file. If you do and there's damage to the header, you can lose all of the backups. Backups should go to individual files,...
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 10, 2014 at 12:57 am
Count(*) can easily be faster than select *. Firstly SQL will use the smallest index on that table (assuming no where clause). Second, less data to transmit.
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 9, 2014 at 4:01 pm
DropCleanBuffers has nothing to do with the plan. It clears the data cache. You don't need to run it for performance testing, just run queries twice or more and ignore...
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 9, 2014 at 2:42 pm
It's worth noting that rebuilds aren't themselves replicated.
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 9, 2014 at 1:39 pm
Koen Verbeeck (7/9/2014)
GilaMonster (7/9/2014)
WHERE Coalesce(NotNullableColumn,-1) = 0and CategoryID = @CategoryID
Group By CategoryID
......
Imo there is not necessarily something wrong with the group by.
The actual query was a little (lot) more complex...
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 9, 2014 at 12:00 pm
You can rebuild it.
What you can't do is drop the primary key, not because it'll break replication, but because you'll get an error if you try.
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 9, 2014 at 11:58 am
WHERE Coalesce(NotNullableColumn,-1) = 0
and CategoryID = @CategoryID
Group By CategoryID
......
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 9, 2014 at 8:47 am
Ncage (7/9/2014)
Ya we do an sp_updatestats every night
So a sampled update. That may be fine, or it may be terrible. Can't tell. Take a look at your poorly performing queries...
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 9, 2014 at 8:22 am
Jack Corbett (7/9/2014)
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 9, 2014 at 8:02 am
I wouldn't say that.
Fragmentation is not that massive of a concern, but rebuilding indexes also removes the half-full pages that you tend to get as a result of page splits....
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 9, 2014 at 7:58 am
Board games on some Saturdays at the local geek hangout. I have Catan, Star Flux, Avalon and Forbidden Island. The club usually has a large pile of demo games. Computer...
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 9, 2014 at 7:02 am
What recovery model is the DB in?
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 9, 2014 at 5:31 am
They would reference a linked server name, which does not have to correspond with the actual server name. When you create the linked server on the new installation, keep the...
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 8, 2014 at 3:35 pm
Viewing 15 posts - 8,491 through 8,505 (of 49,552 total)