Viewing 15 posts - 406 through 420 (of 1,348 total)
a little off-topic but maybe someone can answer this for me
in windows 2003 and later on basic disks i run diskpart and i can create the 64k offset for performance...
April 8, 2010 at 8:51 am
ian-707364 (4/8/2010)
April 8, 2010 at 8:33 am
I think Brent Ozar tested the HP version of this on tempdb a few weeks back. HP rebrands these, but i think they only sell the blade server version under...
April 8, 2010 at 8:28 am
very interesting
we've used something similar to this but a lot simpler for almost 10 year to store business rules for applications and users.
April 6, 2010 at 7:32 am
good article
i had to learn the basics late last year and it's pretty easy to get going to write basic reports. next step for me is to write complicated reports...
April 6, 2010 at 7:18 am
good article
i had to learn the basics late last year and it's pretty easy to get going to write basic reports. next step for me is to write complicated reports...
April 6, 2010 at 7:10 am
can't say the same thing for everyone, but a lot of times its easier and faster to just reinitialize replication than troubleshoot it or migrate it. script it out, and...
April 2, 2010 at 11:46 am
have you looked at the query to see if it can be optimized, indexes created, changed, etc? or how much data it returns?
with 32 bit you are limited to 4GB...
April 1, 2010 at 11:47 am
the differential backup backs up every page or extent that changes since the last full. forgot which on it is. this means that if you run alter index or change...
April 1, 2010 at 9:27 am
Kendal Van Dyke (3/30/2010)
Can you elaborate on the following statement you made:
the number of records in the MSRepl_transactions table is likely to be very high and once it has gone...
March 30, 2010 at 12:57 pm
got the derived column to work. haven't used SSIS much.
data source is the sp then it goes to the derived column that adds the column server_name and populates it with...
March 23, 2010 at 11:52 am
Phil Parkin (3/23/2010)
Or add @@SERVERNAME to your SELECT statement?
how would i do that? the source of the data flow is exec sp_replcounters
March 23, 2010 at 11:30 am
i would script out the publication and run the script on the distributor to create the publication from scratch. or create it from scratch
March 18, 2010 at 1:27 pm
you can add included columns to your nonclustered indexes to minimize RID Lookups
March 11, 2010 at 10:23 am
Luke L (3/10/2010)
SQL Noob (3/10/2010)
March 11, 2010 at 8:08 am
Viewing 15 posts - 406 through 420 (of 1,348 total)