Viewing 15 posts - 8,101 through 8,115 (of 49,552 total)
Chris-354050 (8/14/2014)
Was the purpose in linking the blogs to shame Gail into updating hers? 🙂
SoonTM
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 14, 2014 at 7:06 am
Offhand, no idea.
You should be able to dig up some info on plan shells from 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 14, 2014 at 4:37 am
The ad-hoc ones just shells, not actual plans. They're there so that SQL can link the original query and the parameterisd
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 14, 2014 at 4:18 am
Koen Verbeeck (8/14/2014)
- create a running total on this column.
You can use the quirky update method laid out by Jeff...
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 14, 2014 at 4:06 am
You still haven't explained why the obvious solution, ROW_NUMBER, isn't allowed.
If I needed row numbers in any version of SQL above 2008, I'd use ROW_NUMBER(). If I needed row numbers...
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 14, 2014 at 4:04 am
CLR - Common Language Runtime. .net code in SQL Server. You can create procedures and functions which are written in .Net.
Koen's suggestion wasn't serious (I nope) and besides would violate...
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 14, 2014 at 3:54 am
You could create a temp table with an identity column, insert the data and then query it back.
Why the restriction against the obvious solution (row number)?
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 14, 2014 at 3:41 am
Nope, missing indexes DMV is too dumb to consider filtered indexes (and it's index recommendations need to be very carefully evaluated anyway, but then so do DTA's)
Filtered indexes are something...
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 14, 2014 at 3:40 am
quackhandle1975 (8/14/2014)
GilaMonster (8/12/2014)
What are the error messages? I don't have all of the error codes memorised.An expert would. 😉
Good thing I don't claim to be an expert then, isn't it.
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 14, 2014 at 3:37 am
In general, high level, when you have a fixed predicate that is frequently applied to a table along with other predicates. So if you frequently have <someColumn> IS NULL 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 14, 2014 at 3:14 am
josborne 48714 (8/13/2014)
Full backups that do not use the 'COPY_ONLY' option do indeed break the log chain;
No they don't, and they never have. The only thing that COPY_ONLY does...
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 13, 2014 at 2:12 pm
TomThomson (8/13/2014)
GilaMonster (8/12/2014)
I'd love some rain. It's getting towards the end of winter here and it is soooo dry.
I wish I could give you some of ours. I'm beginning...
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 13, 2014 at 11:31 am
Anyone up for giving Me "I require some help with indexes" some help?
Edit: http://www.sqlservercentral.com/Forums/Topic1602739-391-1.aspx
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 13, 2014 at 11:29 am
Don't suppose you're on SQL 2012? The TRY_PARSE added there is sooooo handy for this kind of thing.
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 13, 2014 at 9:45 am
Sana4u (8/13/2014)
HELP which is required from you is that if you'll look at the Index...
"Required"?
The only people who can "require" me to do some work are my manager 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
August 13, 2014 at 9:44 am
Viewing 15 posts - 8,101 through 8,115 (of 49,552 total)