Viewing 15 posts - 6,421 through 6,435 (of 49,552 total)
You can ensure that the administrator doesn't have a login to SQL, that the Administrators group isn't added as a SQL login (shouldn't be), the domain admins group is 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 recoverability
March 17, 2015 at 2:48 am
However it's worth noting that: http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/
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
March 17, 2015 at 2:43 am
Since that table has nothing to indicate any order of insert (eg dateinserted), there's no way to tell what the latest rows are (tables are unordered sets of rows). If...
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
March 17, 2015 at 2:40 am
Igor Micev (3/16/2015)
wak_no1 (3/16/2015)
Thanks for the reply.Why shouldn't I drop the clustered indexes? - they're not needed (hence why non exist), as they're only needed for the move.
You can use...
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
March 16, 2015 at 8:38 am
SQL Guy 1 (3/16/2015)
When creating clustered indexes, you can add page level compression.
Which is not necessarily a good thing (can massively increase CPU usage). You can compress a heap...
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
March 16, 2015 at 8:12 am
Table doesn't have clustered index != table doesn't need clustered index
All (almost all) tables should have a clustered index as that's what the storage engine is designed around. That 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 recoverability
March 16, 2015 at 7:22 am
EdVassie (3/16/2015)
a) is obviously the EXIST check and b) is the IN check.
Except it isn't. They behave and perform identically in most cases, see the blog post referenced above.
b)...
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
March 16, 2015 at 5:41 am
roger.price-1150775 (3/16/2015)
Triggers might help but could be complex. You would need triggers on both tables to manage/control changes to either table.
Yes, it would. In a situation like this I'd 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
March 16, 2015 at 5:35 am
wak_no1 (3/16/2015)
I'm presented with an issue where by I need to reclaim a fair bit of unused space currently sat in the primary data file for my database. I don't...
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
March 16, 2015 at 5:30 am
It's not a bug.
A bug is a behaviour that is contrary to the way the software was designed to work. What you're seeing is a fully expected (and documented) behaviour...
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
March 16, 2015 at 5:29 am
If they're local variables, it's what Grant said. SQL can't sniff the values and so probably has an incorrect row estimation, one where it thinks that the index it's choosing...
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
March 16, 2015 at 4:31 am
dan-572483 (3/11/2015)
Two messages up GilaMonster describes a scheduled shrink job she has on a dev server.
Emphasis *dev* server (it's mostly there because the developers have a habit...
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
March 16, 2015 at 4:25 am
Gary Varga (3/16/2015)
Phil Parkin (3/16/2015)
GilaMonster (3/16/2015)
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
March 16, 2015 at 3:50 am
The worst comment I've ever seen (as opposed to one I wrote) was in MS Access. The previous developer had written a lot of profanity-filled comments. Anyone who's worked with...
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
March 16, 2015 at 3:03 am
A function will do it, but it can't be trusted because the check constraint on table A won't get checked if the column in table B changes and hence 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
March 16, 2015 at 3:02 am
Viewing 15 posts - 6,421 through 6,435 (of 49,552 total)