Viewing 15 posts - 3,286 through 3,300 (of 7,498 total)
I would stick to using the UNC path so any investigating DBA will immediately recognize the backup is being taken at the other physical location.
backup yourdb to disk="\\theotherserver\abackupshare$\yourdbFULL.bak"
November 23, 2009 at 11:31 am
off course you can add the extra case to evaluate the > 1000.
Keep in mind to actually evaluate on one of the join condition key columns of your B table....
November 22, 2009 at 3:29 pm
at least go for 3th or 4th NF to understand the data and its relationships.
Stick with that as long as you can. (i.e. unless it is proven to be less...
November 22, 2009 at 1:05 pm
- if the service account of the source server has write authority at the target servers backup location, you can initiate the backup to that location without a problem, or...
November 21, 2009 at 2:17 pm
select a.col1, isnull(b.colX,1) as colX
from myobject a
left join myotherobject b
on b.fkcol = a.keycol
have fun .
November 21, 2009 at 2:13 pm
Brandie Tarvin (11/20/2009)
Microsoft has responded to that feedback thread with a request for more information. Were you the one who posted it?
No, it wasn't me.
Because this shrinking of tempdb frequently...
November 20, 2009 at 4:51 am
as stated in all kb stuff already pointed to, you cannot shink tempdb without stop/start of the sqlinstance. (an even if it would succeed, chances are your ongoing operations may...
November 20, 2009 at 3:04 am
If your sql2000 instance is still available, just script out all jobs, alerts, user created objects, ....
and then run that script on your sql2008 instance.
Keep in mind NOT to implement...
November 20, 2009 at 2:44 am
IMO these are very interesting articles on this Disk related subject ...
- Playing with Disk Alignment
http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/11/19/playing-with-disk-alignment.aspx
- SAN Performance Tuning with SQLIO
http://sqlserverpedia.com/wiki/SAN_Performance_Tuning_with_SQLIO
November 20, 2009 at 12:45 am
IMO these are very interesting articles on this Disk related subject ...
- Playing with Disk Alignment
http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/11/19/playing-with-disk-alignment.aspx
- SAN Performance Tuning with SQLIO
http://sqlserverpedia.com/wiki/SAN_Performance_Tuning_with_SQLIO
November 20, 2009 at 12:45 am
IMO these are very interesting articles on this Disk related subject ...
- Playing with Disk Alignment
http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/11/19/playing-with-disk-alignment.aspx
- SAN Performance Tuning with SQLIO
http://sqlserverpedia.com/wiki/SAN_Performance_Tuning_with_SQLIO
November 20, 2009 at 12:45 am
IMO these are very interesting articles on this Disk related subject ...
- Playing with Disk Alignment
http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/11/19/playing-with-disk-alignment.aspx
- SAN Performance Tuning with SQLIO
http://sqlserverpedia.com/wiki/SAN_Performance_Tuning_with_SQLIO
November 20, 2009 at 12:44 am
IMO these are very interesting articles on this Disk related subject ...
- Playing with Disk Alignment
http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/11/19/playing-with-disk-alignment.aspx
- SAN Performance Tuning with SQLIO
http://sqlserverpedia.com/wiki/SAN_Performance_Tuning_with_SQLIO
November 20, 2009 at 12:43 am
Thank you for the feedback.
Now, let's have a virtual pint on behalf of your solution :w00t:
November 19, 2009 at 6:30 am
maybe your table was pinned on sql2000 ?
that nolonger exists on sql2k5
November 19, 2009 at 4:13 am
Viewing 15 posts - 3,286 through 3,300 (of 7,498 total)