Viewing 15 posts - 11,881 through 11,895 (of 49,562 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...
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...
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....
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...
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...
August 30, 2013 at 3:30 am
I hope that good performance is not a requirement.
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...
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...
August 29, 2013 at 4:56 pm
Jay Purvis (8/29/2013)
....
For the money we pay...
August 29, 2013 at 4:47 pm
Erin Ramsay (8/29/2013)
So if...
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...
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....
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.
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...
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...
August 29, 2013 at 6:10 am
Viewing 15 posts - 11,881 through 11,895 (of 49,562 total)