Viewing 15 posts - 106 through 120 (of 1,252 total)
When you say 200 replaces does it mean multiple updates/replaces in a column?
October 28, 2009 at 2:59 am
Yes Intellisense can be a pain at times.
October 28, 2009 at 2:41 am
Hi
You will have to stop SQL Server service. You can do that from Control panel\Administrative Tools\Services. Then you can copy the mdf and ldf files to another db server and...
October 26, 2009 at 11:42 pm
You can use SSIS. Why no scripts?
October 26, 2009 at 11:34 pm
A good backup strategy and regular checking of the database's health (dbcc checkdb) is the best way to handle this.
October 26, 2009 at 11:30 pm
Jeff Moden (10/23/2009)
ChiragNS (10/23/2009)
good one Jeff. Can u explain this part - ORDER BY (SELECT 1). I looked up the order by clause but did not fully understand.
Sure... at the...
October 26, 2009 at 3:07 am
good one Jeff. Can u explain this part - ORDER BY (SELECT 1). I looked up the order by clause but did not fully understand.
October 23, 2009 at 4:31 am
---- Being Around Smart People is Exciting
Being Smart is even More Exciting
October 23, 2009 at 4:12 am
All the best for upgrading to 2008 🙂
October 23, 2009 at 12:59 am
Roust_m (10/22/2009)
ChiragNS (10/22/2009)
The table name and the synonym name would be different. You will have to change the code wherever you have coded with the tablename
Not at all. ...
October 23, 2009 at 12:55 am
Lowell has a good idea but you need to make sure that the support people don't change the password expiry and change the SA pwd itself.
October 22, 2009 at 3:04 am
The table name and the synonym name would be different. You will have to change the code wherever you have coded with the tablename
October 22, 2009 at 2:57 am
Will taking a tail-log backup if possible help?
October 22, 2009 at 2:49 am
Skeeve
Are you using any date columns in the join or the where clause?
It would be helpful for everyone if you could post the table definitions , data to be...
October 22, 2009 at 1:40 am
ChiragNS,
Thanks for the 2 points. I am not going to try the 'page restore' method, but good to be reminded of options. I guess you could do it all with...
October 21, 2009 at 2:32 am
Viewing 15 posts - 106 through 120 (of 1,252 total)