Forum Replies Created
Viewing 15 posts - 23,596 through 23,610 (of 49,552 total)
-
RE: Page File location and Size
You almost must set max server memory on a 64-bit server, with that left at default (2000 terabytes or so), SQL can and will take all the memory on 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
SQLRNNR (9/11/2011)
GilaMonster (9/11/2011)
I think the hard drive failure's worse. Cost me most of last night and a good part of this morning and I'm working on my laptop until 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
bitbucket-25253 (9/11/2011)
The car being mechanical can be repaired. We (I think I speak for most of the denizens of the thread) THANK GOODNESS you were 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
I think the hard drive failure's worse. Cost me most of last night and a good part of this morning and I'm working on my laptop until I can find...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Syntax problem using SELECT.. IN (@variable)
In short, you can't do that. IN takes either a resultset via a subquery or a list of literal values, not a variable.
Options:
* Dynamic SQL (beware SQL injection)
* A splitter...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Index rebuild causes severity 20 error "A system assertion check has failed" involving statutil.cpp
Looking at the error, it appears to be something to do with the statistics (which checkDB doesn't check). Can't tell more than that, CSS can debug system asserts cause they...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
Stefan Krzywicki (9/11/2011)
Weeks! Ugh. When my fiancee got hit by a bus, the main body panel and both passenger side doors were damaged and the biggest time suck was each...Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
That's the driver's door. it's a 2-door car.
The panel with the dent is a single piece from driver's door to bumper, right up and over the roof. It's the same...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
Grr. Minor car accident friday, hard drive failure yesterday. Can i send this weekend back for a refund please?
Minor accident very minor, it's mostly about the shear inconvenience resulting...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Index rebuild causes severity 20 error "A system assertion check has failed" involving statutil.cpp
CheckDB?
If it too comes back clean, make sure you're on the latest service pack and call CSS.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Cursor Causing Performance Issues
That might get you a percent or two improvement at most.
I'd look at the code for that stored proc. See if it can be converted into a set-based update...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: best book for sql server
Of course it's not free. Books cost money to make and print, not to mention the authors do like getting paid.
If you want free there are lots of blogs 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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Index hint: hash, merge in sql server 2000,2005
replace 'Add indexes' with 'add, widen and drop indexes'.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Index hint: hash, merge in sql server 2000,2005
Fix non-SARGable predicates, add indexes, fix catch-all queries (very common), suggest application rewrites (to stop being chatty), simplify SQL code, remove cursors.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Discrepancy in definitions in system tables in same database
From Books Online:
INFORMATION_SCHEMA.ROUTINES
ROUTINE_DEFINITION
nvarchar(4000)
Returns the first 4000 characters of the definition text of the function or stored procedure if the function or stored procedure is not encrypted. Otherwise,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass
Viewing 15 posts - 23,596 through 23,610 (of 49,552 total)