Viewing 15 posts - 3,931 through 3,945 (of 49,552 total)
Tom Staab (12/29/2015)
Regarding your 3 points about statistics, however, I just double-checked my code, and I don't have any SET STATISTICS statements.
I just downloaded the attachment to your...
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
December 29, 2015 at 5:44 am
Another comment:
It is important to note that set-based design will not automatically result in faster performance, especially if that particular query includes subqueries in the SELECT clause. For example,...
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
December 29, 2015 at 5:36 am
To rebuild a 50GB index, you need 50GB free in the data file (at least) and more than 50GB free space in the log file. If you don't have that,...
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
December 29, 2015 at 4:59 am
andrewcamary (12/29/2015)
As suggested above, It is not recommended to shrink database anymore. Instead, you can shrink data file if it required in your environment.
Err.... no. All the comments above about...
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
December 29, 2015 at 4:58 am
Doesn't matter. If there's activity, then SQL will be caching data. That's what uses the most memory.
Check the Total Server Memory counter in perfmon, but chances are, if SQL's been...
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
December 29, 2015 at 2:57 am
I strongly recommend a fresh install. CTPs are notorious for not uninstalling cleanly.
A release date has not been set by Microsoft, hence you won't see any dates.
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
December 29, 2015 at 2:20 am
If you've told SQL it's allowed to use 14GB of memory, there's a very good chance that it's using all 14GB.
Why are you certain it's not using the full memory...
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
December 29, 2015 at 2:19 am
"Rollback to a saved inner transaction"
Careful there. SQL doesn't actually have nested transactions. It's a syntactical lie. If there's a rollback inside nested transactions, everything is rolled back, not to...
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
December 28, 2015 at 3:04 am
vivekgrover44 (12/28/2015)
How does fragmentation causes slow updates of a large table? Could you please put light on this?
It doesn't usually, which is why I said to check whether 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
December 28, 2015 at 3:00 am
Yes. All editions can read compressed backups. The Enterprise limitation is on creating 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
December 26, 2015 at 2:54 pm
Mine would have to be UPPER(LTRIM(RTRIM(<SomeColumn>) = @Parameter, in a case-insensitive database where none of the rows have leading whitespace.
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
December 25, 2015 at 2:00 pm
GonnaCatchIT (12/24/2015)
Is it a good design to drop and create indexes at run time
Not usually. It's done for bulk inserts, less so updates, but test both ways and see.
Also,...
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
December 25, 2015 at 1:33 pm
I see these sooo many times: https://www.simple-talk.com/content/article.aspx?article=2280, plus scalar UDFs, multi-statement table-valued UDFs, nested views, non-SARGable predicates
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
December 25, 2015 at 1:31 pm
Robert klimes (12/24/2015)
IMO, the best bet would be to create the 2014 cluster on new hardware and then migrate database(s),logins, jobs,etc to new instance.
This.
I don't think you can convert...
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
December 24, 2015 at 1:28 pm
Eirikur Eiriksson (12/24/2015)
Quick question, are you storing passwords in plain text?😎
Looks that way. So a bunch of T-SQL problems that Kevin picked up and a critical, major security flaw.
Passwords should...
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
December 24, 2015 at 1:23 pm
Viewing 15 posts - 3,931 through 3,945 (of 49,552 total)