Viewing 15 posts - 16,621 through 16,635 (of 39,827 total)
Anipaul (3/9/2011)
Will all the stairway articles later published in a book for collection? The articles are great...
This is probably what we will do when they are completed. So once we...
March 9, 2011 at 8:06 am
Jim has explained this well. It's mostly so you can get a valid comparison of two different sets of code that do the same thing. You can't count on these...
March 8, 2011 at 5:29 pm
taylor_benjamin (3/8/2011)
I am not sure, but as...
March 8, 2011 at 10:14 am
T-Log backups typically don't have a huge impact on performance, but there is writing to the IO subsystem, so there could be some contention there, depending on your setup. If...
March 8, 2011 at 9:38 am
Anthan has the best suggestion I've seen. I might do some metrics, maybe a large copy to the disks or something to test the current performance, and then another test...
March 8, 2011 at 9:36 am
If the log grew, shrinking isn't necessarily the solution. It fixes things, but please read Gail's (GilaMonster) article and make sure you have full backup set up.
March 8, 2011 at 9:34 am
I think you'd be better copying the data into a new table, with the changed data type, then building nonclustered indexes, then renaming the old, and rename the new.
If you...
March 8, 2011 at 9:13 am
A little old, but this might give you some pointers on setup
http://www.sqlshare.com/clustering-sql-server-2005_33.aspx?searchid=150263
March 8, 2011 at 9:01 am
jcrawf02 (3/7/2011)
March 8, 2011 at 8:56 am
So, you're still saying this is simple, but it's not as simple as you ask.
If this is the same server instance, then names matter. If this is another instance, then...
March 8, 2011 at 8:53 am
Possible that -c is causing an issue. I wouldn't expect that, but a quick test ought to fix it.
However if the data is wrong in the source tables, the bcp...
March 8, 2011 at 8:48 am
tgarland (3/7/2011)
March 8, 2011 at 8:46 am
Koen Verbeeck (3/8/2011)
taylor_benjamin (3/8/2011)
Thanks for reminding me how old I am, and how long I have been working with SQL Server. 🙂There was a 4.21 version??? 😛
There was a version...
March 8, 2011 at 8:44 am
GilaMonster (3/8/2011)
Koen Verbeeck (3/8/2011)
If a data load fails, the destination table can be truncated and the load can start over again, so you would not have to worry about inconsistency.
What...
March 8, 2011 at 8:43 am
Thanks for the update, and a good catch.
I might set a script to do all these things before and after the DR test, so that you have a set start...
March 8, 2011 at 8:37 am
Viewing 15 posts - 16,621 through 16,635 (of 39,827 total)