Viewing 15 posts - 11,881 through 11,895 (of 49,552 total)
Abu Dina (8/30/2013)
I wonder if the TOP is making SQL Server materialise the query in tempdb then it applies the scores?!
No. Top just applies a row goal. It doesn't materialise...
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
August 30, 2013 at 6:25 am
kevaburg (8/30/2013)
2. "Shrink the datafile by migrating the data to other files in the same filegroup" performed from within the file properties dialog box of the SHRINK FILE task.
ShrinkFile...
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
August 30, 2013 at 6:21 am
No need to shrink, and shrinking will NOT have any effect.
Wait until the entire active portion of the log is in the file you want to keep (use DBCC LogInfo....
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
August 30, 2013 at 6:20 am
Junglee_George (8/30/2013)
Thanks Gail. But Chris hasn’t written the code for the splitter function there. I need that code.
It's not his code. It's from an SSC article and a quick google...
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
August 30, 2013 at 3:57 am
This kind of query is a common problem with known, tested, well-performing solutions. There's no need to re-invent the wheel here.
See Chris's query using a splitter function or consider a...
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
August 30, 2013 at 3:30 am
I hope that good performance is not a requirement.
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
August 30, 2013 at 3:14 am
Robert Davis (8/29/2013)
GilaMonster (8/29/2013)
When did you last see someone specifying the mantissa for a float? If not specified (as in the OP), the default is 53, which requires 8 bytes.
I...
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
August 29, 2013 at 5:01 pm
ScottPletcher (8/29/2013)
Float only takes 4 bytes to store if you specify a precision of 24 or less.
When did you last see someone specifying the mantissa for a float? If not...
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
August 29, 2013 at 4:56 pm
Jay Purvis (8/29/2013)
....
For the money we pay...
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
August 29, 2013 at 4:47 pm
Erin Ramsay (8/29/2013)
So if...
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
August 29, 2013 at 4:42 pm
Erin Ramsay (8/29/2013)
So the len() function is counting bytes instead of digits? Is this particular to floats?
LEN takes a string as a parameter and counts the number of bytes 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
August 29, 2013 at 4:39 pm
From Books Online
float
Approximate-number data types for use with floating point numeric data. Floating point data is approximate; therefore, not all values in the data type range can be represented exactly....
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
August 29, 2013 at 4:34 pm
You can't revoke or deny to a sysadmin account. The login named 'sa' cannot have any permissions changed, it can only be disabled.
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
August 29, 2013 at 7:10 am
There's an undocumented command that reads the log backup too, but I doubt it will help much. Unless someone is very, very familiar with the log internals, that'll just return...
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
August 29, 2013 at 6:29 am
Koen Verbeeck (8/29/2013)
Are you saying you can't speed up inserts with minimized logging or partition switching?
Was the OP talking about large bulk inserts? They're not going to improve the performance...
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
August 29, 2013 at 6:10 am
Viewing 15 posts - 11,881 through 11,895 (of 49,552 total)