Viewing 15 posts - 9,316 through 9,330 (of 22,214 total)
Where's Red Gate Press?
I've got several of their books on my desktop and not just because I work/write for them.
December 4, 2013 at 11:06 am
Wonderfully excellent advice already posted here. I'll add one more. Check out Jason Strate's Monthly DBA Checklist[/url]. It's a pretty good starting point for ensuring you have the basics in...
December 4, 2013 at 7:01 am
As much as possible, always go to the documentation in Books Online first.
Here are the requirements for Memory Optimized Tables. It's 64 bit and Enterprise only (or Development, yes).
As...
December 4, 2013 at 6:57 am
Go into SQL Server Management Studio and change the security settings for that login so that it can't access the other database. Here's an introduction to security in SQL Server.
December 4, 2013 at 6:53 am
I'd suggest taking a look at sys.dm_exec_requests to see what the process is waiting on. You'll at least understand where the bottleneck lies.
December 4, 2013 at 6:49 am
How big are those tables? Tables that are less than a single extent in size won't defrag at all. Tables that are smallish, say 2-3 extents, may not defrag fully....
December 4, 2013 at 6:43 am
I prefer backup and restore where I can do it (primary limitation would be disk space) because you don't ever risk the fundamental data files. Detach and attach, you take...
December 4, 2013 at 6:40 am
Jeff Moden (11/20/2013)
This is a very good example of why you should (and I don't use the word often) ALWAYS use the two part naming convention. 😉
Absolutely.
On both points, using...
December 3, 2013 at 10:59 am
I very seldom use the built-in roles. I always build the roles custom. but, I only build them as needed. Not all roles are ever needed on all databases. And,...
December 3, 2013 at 10:54 am
Not seeing the maintenance plan or your structure, I'm not sure. But, something is wrong. That name is not there. It's the wrong schema, it's been renamed while you were...
December 3, 2013 at 7:52 am
Ah, infinite loop. Yeah, that'll keep executing.
December 3, 2013 at 7:14 am
Missing a commit statement? You used dirty reads (read uncommitted)? Something along these lines could easily explain it.
December 3, 2013 at 6:37 am
If you have enforced referential integrity between the two tables, you won't have to check, SQL Server will do that for you. If that value does not exist, you will...
December 3, 2013 at 3:32 am
But you can have a primary key and then a number of different unique constraints. Just because there is more than one possible candidate key in the table doesn't limit...
December 3, 2013 at 3:28 am
Seems reasonably clear. This error: Cannot find the object "dbo.TentFlowDetail_33_3439843"
It can't find the object to rebuild it. You are either passing in the wrong object name, or the wrong...
December 3, 2013 at 3:25 am
Viewing 15 posts - 9,316 through 9,330 (of 22,214 total)