Viewing 15 posts - 106 through 120 (of 394 total)
if you have text data in your table, there is a good chance that table size will not be reflected properly under the scipt posted above
June 18, 2009 at 6:24 pm
I guess that script should be smth like that:
If exists (select * from TEMPDB.sys.sysobjects where id = object_id(N'[TEMPDB].[dbo].[#tbl_info]'))
Drop table [#tbl_info]
Create Table #tbl_info (
tblName...
April 8, 2009 at 5:58 pm
How do you connect to that server? I have linked servers running in 3 domains without ( well, almost) problems. Can you verify that there are no blocking on, say...
December 23, 2008 at 4:36 pm
check http://www.sql.ru and look for sql server links
November 28, 2008 at 11:22 pm
Also keep in mind that you might get a lower salary ( compare to the current one) when get a Junior position...
September 2, 2008 at 10:13 am
It might take some time, so be patient. Did you make some research for jr. DBA position. Try to post your resume on Dice\Monster and see if you start getting...
September 1, 2008 at 9:16 pm
I had almost similar issues when running linked servers against multiple domains. Same domain worked fine. I couldnt execute a remote StoredProc to get space info ( as well as...
July 17, 2008 at 5:57 pm
Shrinking leads to Fragmentation. Also most likely within 3-6 months this space will re-populated by your DB. One of the main reasons to shrink space in your DB ( and...
July 8, 2008 at 5:22 pm
You might want to add the following to your routine, plus you might want to re-sync your stand by server every weekend. Before starting your maint, you disable logshipping. Once...
July 8, 2008 at 11:17 am
Instead of using T-SQL you could use some of the reload.bat where you could pass your db names from predifined list of databases, copy and restore them (using some common...
June 12, 2008 at 4:58 pm
I used to work in one Fin company and it was a tendency among certain groups ( managers) to hire people of the same origins, so it would be easier...
June 6, 2008 at 5:12 pm
At some point I have a table with 3.8 bln records and it works fine on SS2000 Ent.
Reindexing take long time though, then I had to do shrinking which took...
June 5, 2008 at 5:29 pm
From what I heard it is available only in the Enterprise
May 6, 2008 at 5:10 pm
From my personal experience using SQL LiteSpeed I would rather recommend perform backup, restore and delete all tables that no longer needed. And it takes probably less time...
April 15, 2008 at 4:18 pm
Viewing 15 posts - 106 through 120 (of 394 total)