Viewing 15 posts - 16 through 30 (of 68 total)
I'd write (aka download from google) a vb script to do the job then either use Windows scheduled task widget to run it or create a DOS batch file which...
June 19, 2009 at 4:11 am
Vani (6/5/2009)
Has anybody deployed DM in production?
Yes. 🙂
It's basically a poor man's clustering solution - it has good bits and some limitations. It works well in production and allows...
June 10, 2009 at 7:36 am
There is one backup appended to the other? Pick the most recent.
When you say there's two mdf and two ldf files in there, what tool are you using to...
June 5, 2009 at 4:13 am
You need to establish what makes each record unique (ie should every email address or employee number) be unique.
If there's a single column which determins this then use something like
SELECT...
June 3, 2009 at 6:59 am
Ad-hoc reports aren't a problem, they usually come to me and say, "Can you get this info" and I don't care if it takes 5 seconds or 5 minutes to...
June 3, 2009 at 2:34 am
A huge thankyou to all who replied. 😀 I was so busy looking at memory tables and then joining them with the original I lost sight of the...
May 19, 2009 at 6:42 am
It's all 32-bit :crying: and unlikely to move to 64-bit
All the connections are from websites so asp and .NET 2 with connection pooling. The database is ~30Gb so nothing massive...
May 13, 2009 at 8:41 am
As with so many things SQL related, it depends. 😉 What's the db going to be mainly used for , by how many users , how many transactions per...
May 6, 2009 at 10:10 am
If I have a bit field in a table tend to give it a default value and avoid the problem with NULL altogether. That way there's no confusion as...
April 30, 2009 at 8:14 am
As others have said, don't let them run ad-hoc queries against the production system for their reports, it will all end in tears. People with no appreciation for SQL...
April 28, 2009 at 9:54 am
Thanks all for your suggestions.
Since this is only a copy of the live db for the developers to run their dev code against I've gone with the off-line approach. ...
April 24, 2009 at 8:28 am
With mirroring, I would recommend you have a witness server to make full use of the technology. We've run tests to similate a hardware loss (yanked the power out...
April 23, 2009 at 3:15 am
Check the available space on your C drive, especially if the tempdb is stored on there.
Oh and if your mdf file is only 100Mb, you shouldn't have a log of...
April 21, 2009 at 7:08 am
Jack Corbett (4/2/2009)
Have you verified that the linked server user has Select permissions on the table(s) where the queries are failing?
Yes.
However I have finally tracked down the answer: For...
April 2, 2009 at 7:09 am
SQL 2005 Standard Ed :crying:
:ermm: Any suggestions how long this might take (in hours) so I can prepare for the phonecall of doom (at 3am when the server throws in...
January 27, 2009 at 9:29 am
Viewing 15 posts - 16 through 30 (of 68 total)