Viewing 15 posts - 11,596 through 11,610 (of 49,552 total)
Angeltica (9/24/2013)
This is something what is being configured by Microsoft script best practice configuration.
To be honest, I wouldn't trust some of MS's recommendations. You cannot make a blanket statement as...
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 24, 2013 at 12:18 pm
Bhuvnesh (9/20/2013)
Preethi S Raj (9/20/2013)
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 24, 2013 at 8:54 am
Preethi S Raj (9/24/2013)
when the column is (a) an included column and (b) the last indexed column in a partition...
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 24, 2013 at 8:53 am
No where near enough information to make anything other than a wild guess.
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 24, 2013 at 7:34 am
I very seldom use table variables. In functions because that's the only thing allowed, but then I avoid functions as far as possible. Only really useful when the lack of...
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 24, 2013 at 7:33 am
Knives85 (9/24/2013)
Thanks for the response, what do you mean use POWER? I'm not aware of that function.
The built-in system function POWER. If you're not familiar with it, look it up...
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 24, 2013 at 6:55 am
You don't get at the tables. They're hidden system tables, you can't even see them let alone query them. Use the catalog views, that's what they are there for.
If you...
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 24, 2013 at 5:51 am
Functions are poor in joins for the same reason they're poor in where. It's non-SARGable and the functions are executed once per row. Horrid combo.
Table variables inhibit parallelism. Put one...
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 24, 2013 at 5:15 am
In SQL, ^ is a bitwise exclusive OR. You'll be wanting the POWER function.
SELECT POWER(2,3) -- 8
SELECT POWER(5,2) -- 25
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 24, 2013 at 5:10 am
I said it won't necessarily cause slow queries, not that it won't ever cause slow queries, and you really don't need to quote from a book I helped write.
Slow 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 24, 2013 at 4:06 am
Please post table definition, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/. At absolute minimum, we need the execution plan. There's no way to guess query performance without. Those '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 24, 2013 at 4:04 am
Configuration information is in sys.configurations.
Logins are in sys.server_principals (sys.syslogins is deprecated, should not be used)
Database users are in sys.database_principals (sys.sysusers is deprecated, should not be used)
Permissions are in sys.server_permissions 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
September 24, 2013 at 4:03 am
I'd recommend this be done in the client app, not in SQL. SQL's string handling is very weak compared to what the .net framework has.
Also consider what happens when people...
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 23, 2013 at 4:27 pm
And now that the paperwork has been signed....
November it's good bye consulting, back to full time grind. Starting at a software development house as a technical lead. Focusing on SQL...
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 23, 2013 at 2:02 pm
LOVER OF SQL (9/23/2013)
" If you have 4 processors, you could start 4 MDF" (in the case, i'll have 5 datafiles all right? (4 for ndf) and (1 mdf-default), ok?
No....
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 23, 2013 at 11:15 am
Viewing 15 posts - 11,596 through 11,610 (of 49,552 total)