Viewing 15 posts - 796 through 810 (of 1,157 total)
Jeff Moden (10/15/2011)
Aspet Golestanian Namagerdi (10/15/2011)
October 16, 2011 at 8:42 am
Relational theory is all about de-duplicating data for accuracy and rapid querying. If you are struggling then you are missing out on what this question is trying to teach...
October 16, 2011 at 7:17 am
rgtft (10/15/2011)
pintoam (10/15/2011)
Sandra’s Ski Hire rents out skiing equipment..
.
.
Please email the answer to pintoam@hotmail.com....
You're going to get more out of your homework assignment if you put some of your...
October 16, 2011 at 4:02 am
Amanda Bates-348384 (10/12/2011)
Additional Random Meetings ...
October 16, 2011 at 3:57 am
ananda.murugesan (10/14/2011)
Please tell me & suggestion, what could be issue when move to node 1 to node 2 then automatically disconnect SQL SERVER connection?Thanks in advance
ananda
Some of the information...
October 15, 2011 at 8:19 am
I would look at filegroups and partitioning for you backups. Its difficult to say if this would be suitable without knowing your applications and their logic.
October 15, 2011 at 5:50 am
You can check for open connections to the database through Activity Monitor or using sp_who2 through a query window.
You can kill open connections to the database using the...
October 13, 2011 at 9:08 am
As previously mentioned, merge or peer to peer replication will fulfill your needs.
To throw something else out there, depending on the complexity, you could also do this with SSIS.
October 13, 2011 at 7:46 am
Sean Lange (10/12/2011)
I wouldn't argue the rationale for using NOLOCK as a routine hint for queries but I would say that performance IS the reason your shop uses it. In...
October 12, 2011 at 12:47 pm
MysteryJimbo (10/12/2011)
Sounds like a bit of grey area.
I suggest you seek clarification with Microsoft.
October 12, 2011 at 9:59 am
Ninja's_RGR'us (10/12/2011)
Once you tell them it's...
October 12, 2011 at 9:57 am
Sounds like a bit of grey area.
It could probably be argued either way as to whether this is a production use or not. Obviously, one of those...
October 12, 2011 at 3:05 am
There are a lot of scripting problems in SSMS, some are pretty dangerous if you use replication or have large tables.
Including them in the application is useful and allows for...
October 11, 2011 at 4:30 am
Stop the distribution agent for one of the subscribers. In a push topology you will find it on the distributor, in a pull one you'll find it on the...
October 10, 2011 at 10:32 am
What is stored in the ntext column? That will be the cause
October 10, 2011 at 10:21 am
Viewing 15 posts - 796 through 810 (of 1,157 total)