Viewing 15 posts - 1,726 through 1,740 (of 49,552 total)
Please note: 9 year old thread.
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
March 1, 2017 at 2:45 am
No. If you want the data out of those temp tables in a particular order, you need an ORDER BY on the select that retrieves from the temp table. 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
We stand on the bridge and no one may pass
March 1, 2017 at 2:38 am
Natively compiled procedures aren't in memory. They're stored just like other stored procedures in the system tables, and then compiled into dlls as well. It's the In-memory tables which are...
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
February 28, 2017 at 9:02 am
Amazing that a lump of fried dough the size of...
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
February 28, 2017 at 6:26 am
p.s. 16 CPU cores and 16GB memory is a weird combo. My laptop has 16GB memory, a server with 16 cores should have quite a bit more. 64 would be...
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
February 28, 2017 at 5:56 am
Creating 9 narrow indexes for a single query is a waste of time. In most cases, SQL will only use a single index per table per query, and it prefers...
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
February 28, 2017 at 5:55 am
Reinstall Windows 😀
Seriously now. Is SSMS usable, or does is close after displaying that dialog?
Is that the latest version of SSMS?
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
February 28, 2017 at 5:50 am
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
February 28, 2017 at 5:22 am
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
February 24, 2017 at 7:35 am
More or less (and probably forgotten a few)
GW Basic (on an IBM)
Pascal
Modula 2
C++
8086 assembler
SunSparc assembler
PL-SQL
VB Script
Visual Basic
T-SQL
C#
R...
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
February 24, 2017 at 2:32 am
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
February 24, 2017 at 2:23 am
Steve Jones - SSC Editor - Thursday, February 23, 2017 4:05 PMIt's cold and snowy. That's the reason.
Overcast, raining and cold. And...
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
February 24, 2017 at 2:10 am
For the log backup at that time to be so large, there must have been some large operation running between 05:00 and 05:30. Log backup sizes are not directly affected...
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
February 23, 2017 at 6:27 am
Log backups aren't affected by the size of tables, just to activity.
Is the 05:30 backup also larger than other log backups, or just slower?
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
February 23, 2017 at 5:02 am
the FAST n hint says to return the first n rows as fast as possible, even if the overall query takes longer. So operations that start returning rows immediately are...
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
February 22, 2017 at 1:49 pm
Viewing 15 posts - 1,726 through 1,740 (of 49,552 total)