Viewing 15 posts - 6,421 through 6,435 (of 49,571 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...
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/
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...
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...
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...
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...
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)...
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...
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...
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...
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...
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...
March 16, 2015 at 4:25 am
Gary Varga (3/16/2015)
Phil Parkin (3/16/2015)
GilaMonster (3/16/2015)
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...
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...
March 16, 2015 at 3:02 am
Viewing 15 posts - 6,421 through 6,435 (of 49,571 total)