Viewing 15 posts - 16,651 through 16,665 (of 49,552 total)
You might also want to have a read through this: http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-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
September 13, 2012 at 3:22 am
Varchar(max) Sparse???
That's an incredibly weird definition.
LOB columns take a 16 byte overhead unless null (that's normal, don't need sparse for that). If they're defined sparse but are populated, they take...
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
September 13, 2012 at 3:21 am
Please note: 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
September 13, 2012 at 2:28 am
SQLSACT (9/13/2012)
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
September 13, 2012 at 2:17 am
Go to the MCP site (you should have got an email invite if it was your first exam) and check your transcript. That shows all the certs you have.
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
September 13, 2012 at 2:01 am
SQLSACT (9/13/2012)
GilaMonster (9/13/2012)
SQLSACT (9/13/2012)
When SQL Server brings pages into Memory, the pages sit in memory in the same way as they were sitting on disk?
Meaning?
When the query is submitted for...
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
September 13, 2012 at 1:51 am
SQLSACT (9/13/2012)
When SQL Server brings pages into Memory, the pages sit in memory in the same way as they were sitting on disk?
Meaning?
When the query is submitted for the second...
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
September 13, 2012 at 1:36 am
I asked for the full and complete output. I asked for that for a reason, one cannot make sensible recommendations about fixing a DB from partial output from CheckDB
Now, please...
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
September 13, 2012 at 1:17 am
First time:
Query is compiled
Query is executed
Query processor asks for rows one by one from the storage engine according to the query operators in the plan
Storage engine returns the rows from...
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
September 13, 2012 at 1:16 am
sqlharmony (9/12/2012)
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
September 12, 2012 at 4:39 pm
Honestly, nearly impossible. You'd have to change the application, where the SQL is embedded. Somehow I doubt you have permission for that.
May I suggest plan guides? Optimise for unknown hint...
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
September 12, 2012 at 4:11 pm
Well, both of those statements are incorrect, so probably better to just ignore them...
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
September 12, 2012 at 3:51 pm
Edit -> Bookmarks -> Toggle bookmark
Then to navigate between bookmarks Edit -> bookmarks -> Next bookmark in document or Edit -> bookmarks -> Previous bookmark in document
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
September 12, 2012 at 3:50 pm
If you mean putting single column indexes on every column, probably not.
http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-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 recoverability
September 12, 2012 at 3:45 pm
You have parameter sniffing problems
http://www.simple-talk.com/sql/t-sql-programming/parameter-sniffing/
http://www.benjaminnevarez.com/2010/06/the-parameter-sniffing-problem/
If you have ad-hoc or prepared SQL embedded in the app, it'll be a pain to fix. In stored procedures it's much simpler.
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
September 12, 2012 at 3:45 pm
Viewing 15 posts - 16,651 through 16,665 (of 49,552 total)