Viewing 15 posts - 19,186 through 19,200 (of 26,484 total)
hi_abhay78 (8/14/2009)
First create or modify a job and run profiler at the background...
August 14, 2009 at 9:40 am
No website required. You can get all of this from BOL (Books Online, the SQL Server Help System). You can access it from SSMS by pressing the {f1}...
August 14, 2009 at 9:05 am
Gift Peddie (8/14/2009)
I think you may have missed the where clause in my LEFT JOIN example. All three of these queries will return the same result set. ie Customer records...
August 14, 2009 at 9:01 am
There may be another solution as well. Could you please post the DDL for the tables involved (not just the ones in the procedure), sample data for the tables,...
August 14, 2009 at 8:57 am
First, you may nneed a cursor. To really help you, we need your help. Please provide the DDL for the tables, sample data for the tables, expected results...
August 13, 2009 at 11:53 pm
There are numerous ways this can be accomplished. You may want to google Geographically dispersed clusters. There is software that will allow you do to this, but it...
August 13, 2009 at 11:47 pm
htt (8/13/2009)
As soon as you perform a new full backup, you have reinstated the log chain and all transactions are being captured
This is NOT always true. Couple of my...
August 13, 2009 at 11:15 pm
Only speaking for myself here, but I think others may agree; for me to leave SSC the sense of Professional Community that currently exists would have to leave the site....
August 13, 2009 at 11:08 pm
Let me think on that a bit. The first idea I had was to have you zip and upload the .dtsx package, but that may not work, even though...
August 13, 2009 at 10:57 pm
htt (8/13/2009)
Okay, here is a scenario for you.
At 12:10 PM Wednesday afternoon your server crashes and corrrupts your database forcing a restore. You attempt to restore from the full backup...
August 13, 2009 at 10:49 pm
Not sure if it will help, but have you looked into full text indexing?
August 13, 2009 at 7:47 pm
Sorry, but I can't see from here what you see from there. Little hard to help.
August 13, 2009 at 7:45 pm
Unless you are having space issues on the disk, don't. If it has grown to that size, it has for a reason. Shrinking it will only make it...
August 13, 2009 at 6:54 pm
htt (8/13/2009)
Until you get to SQL Server 2008 where the truncate option no longer works. Besides, why truncate the log right after you have backed it up? Doesn't...
August 13, 2009 at 6:23 pm
nigelc (8/13/2009)
even though the log file is twice the size of the data File?I thought a full back up atomically truncates the log file
No. Only transaction log backups will...
August 13, 2009 at 6:18 pm
Viewing 15 posts - 19,186 through 19,200 (of 26,484 total)