Viewing 15 posts - 10,411 through 10,425 (of 22,213 total)
Abu Dina (9/21/2012)
Grant Fritchey (9/21/2012)
Abu Dina (9/21/2012)
You get a phone call from one the users. They tell you the database is slow. What do you do?
You answer that reasonably well,...
September 21, 2012 at 9:07 am
Abu Dina (9/21/2012)
You get a phone call from one the users. They tell you the database is slow. What do you do?
You answer that reasonably well, you're hired. You start...
September 21, 2012 at 8:25 am
Jeff Moden (9/21/2012)
raghu14319 (9/20/2012)
plz send some interview scenarios on sql dba
Gosh... just do a Google search and you'll get more questions and answers (caution... some are wrong!) than you can...
September 21, 2012 at 7:13 am
Yeah, I've been in similar situations before too. All you can do is make your case. If all else fails, try this excuse[/url].
September 21, 2012 at 5:03 am
golak_senapati (9/20/2012)
After migrating to SQL Server 2008, how can I get to know that all the tables are migrated successfully with its data (accurate data)?
It's a backup and restore, or...
September 20, 2012 at 1:23 pm
Ooh, just spotted this, for examples, unless you're trying to set a standard as @parm1, etc. (and if so, no, no, no) I wouldn't use those in any examples. Make...
September 20, 2012 at 7:42 am
SQLSACT (9/20/2012)
Grant Fritchey (9/20/2012)
SQLSACT (9/20/2012)
Grant Fritchey (9/20/2012)
SQLSACT (9/20/2012)
Grant Fritchey (9/20/2012)
September 20, 2012 at 6:54 am
SQLSACT (9/20/2012)
Grant Fritchey (9/20/2012)
SQLSACT (9/20/2012)
Grant Fritchey (9/20/2012)
September 20, 2012 at 6:45 am
ananda.murugesan (9/20/2012)
Total server memory 8 GB, I have set it max memory 6GB but SQL side using 5.79 GB, so it seems ok in sql side....
September 20, 2012 at 6:42 am
First, Microsoft supplies a tool called the Upgrade Advisor. You can download it. Run that against the existing databases to ensure there are no issues for the upgrade. Fix anything...
September 20, 2012 at 6:39 am
anthony.green (9/20/2012)
http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ Chapter 4 - memory management
+1000
September 20, 2012 at 6:36 am
SQL Server will allocate all the memory you tell it can allocate. It will take it all, and keep it. It manages it's own memory internally. So if you have,...
September 20, 2012 at 6:24 am
Brandie Tarvin (9/20/2012)
Thanks, guys. I'll take a look at those.FYI, there's a "new" IE flaw: http://redmondmag.com/articles/2012/09/18/ie-flaw-being-actively-exploited.aspx
Running only on the POF now, I no longer worry about viruses or exploits because...
September 20, 2012 at 5:57 am
Well, an SP is going to do the code correctly, yes. But the idea behind a constraint is to make sure things are enforced, regardless of where the code is...
September 20, 2012 at 5:53 am
PiMané (9/20/2012)
Is it possible to have a column on table A that references table B or table C depending on another column on table A?
For example:
EntityAddresses (EntityAddressId, EntityType, EntityID, Address)
Customers...
September 20, 2012 at 4:41 am
Viewing 15 posts - 10,411 through 10,425 (of 22,213 total)