Viewing 15 posts - 76 through 90 (of 464 total)
As far as mirroring is concerned I believe that you can mirror from 2005 to 2008, but you won't be able to fail back to 2005 - which really makes...
October 26, 2009 at 11:11 am
Did you evaluate database mirroring as an alternative to log shipping? It somewhat depends on distance between the servers, but it might serve your purposes in terms of making...
October 8, 2009 at 2:58 pm
Agree with the above. I use SSIS to automate my nightly backup and offsite FTP process, but really it's just a nice wrapper for a few different scripts. ...
October 8, 2009 at 2:50 pm
If the problem is parameter sniffing (and it seems likely) then there are two paths that you can take. The first is the correct path - determine which parameters...
October 8, 2009 at 2:00 pm
Chances are that you will get the same execution plan, but with different actual counts. It would be helpful if you can determine the range of parameter values that...
October 7, 2009 at 11:16 am
Same. If you had to port an app to Oracle for example, then delete queries would be one of the easier conversions. In my experience, ANSI standards only...
September 30, 2009 at 10:16 pm
I doubt you can do it with the import wizard, maybe with SSIS ... the problem is that each line has different segments so it doesn't map readily to a...
September 30, 2009 at 10:08 pm
An alternative to running a trace would be to periodically capture cached query plans in xml format (from sys.dm_exec_query_plan and sys.dm_exec_cached_plans), and interrogate the results for occurrences of the table,...
September 18, 2009 at 8:23 am
I'm not aware of any problems in what you are trying to do - the log formats are the same.
September 16, 2009 at 3:43 pm
rja.carnegie (9/2/2009)
Why doesn't "SELECT COUNT(*) FROM table" look at an index, which apparently it doesn't(?)
It should pick the smallest index (by page reads).
September 2, 2009 at 8:58 am
If you don't need to do this on the SQL side you could run a regex on the client side (meaning the calling process) before displaying/emailing the data. If...
August 18, 2009 at 3:27 pm
jpowers (8/12/2009)
Personally, I would prefer to pay only for the channels I watch. I see no reason why they can't allow us to pay just for our preferred entertainment.
I'm sure...
August 13, 2009 at 12:47 pm
TheSQLGuru (8/12/2009)
4) IIRC you do not need license to do restore-only activity.
Unless it has changed within the year, a restore-only server does requires a license and you pay maintenance on...
August 12, 2009 at 9:05 am
Jeff Moden (7/24/2009)
happycat59 (7/23/2009)
Using COUNT(1) requires SQL Server to return all records that meet the criteria.
Ummmm.... nope... it doesn't... it stops searching as soon as it finds one record that...
July 24, 2009 at 1:37 pm
Is CPU pegged while the backups are running?
Do the databases contain a lot of information that is already compressed or unsuitable for compression?
What compression ratio do you get if...
July 24, 2009 at 9:26 am
Viewing 15 posts - 76 through 90 (of 464 total)