Viewing 15 posts - 46 through 60 (of 107 total)
I'm trying a script for all indexes in the database and I have almost 1/2 hour since I started it and he is still runing.Is it normal?Or should I take...
March 17, 2009 at 10:13 am
Ok man
Thanks for all your advices
A last question : the shrinkdb has any side effects?
March 17, 2009 at 4:26 am
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
March 17, 2009 at 4:14 am
I'm a bit stupid but I have some difficulties. To find Standard Reports I have to conect to Reporting Services? Because I connect to Database Engine, and I don't seem...
March 17, 2009 at 3:15 am
Ok
Thanks for the reply and another question.
If the difference is biger ,backup 20 Gb and the archive 500 Mb, is this still normal?
I was thinking to search the character columns...
March 17, 2009 at 2:23 am
Yes, I tested first, and I was lucky, because there were no problems
But if there were...I don't know if I could solve them
Anyway....I solve the problem . I'm not...
March 16, 2009 at 6:44 am
The whole database is 9 Gb
I have Cascade Update ok the Fk, but no Cascade Delete.
Unfortunetly I've "made a move" untill I read your replies.
I droped all...
March 16, 2009 at 1:57 am
59 SUSPENDED saEUGEN .AntaresDELETE ...
March 14, 2009 at 5:25 am
I'm working from SSMS
The query is : DELETE FROM Users
WHERE Username like 'KO%'
...
March 13, 2009 at 11:30 am
Now I tried deleting "by hand", in SSMS, from the table a record an I receive again time out
The number of records in the table is 3000, and the table...
March 13, 2009 at 11:03 am
my tables contain data for activities that happen daily in a company,that's why it is so big...
Records are inserted at every hour. Are synonyms still a solution?
February 4, 2009 at 9:00 am
I looked at synonyms a little and they seem a good option.
But I have the same question as for views: do they work good with big tables?
And you suggest that...
February 4, 2009 at 8:15 am
Hmmm
really new ideas...
Does it worth using a view if the tables contain lots of records? and if the table is always growing ?
I haven't heard of the second option. I...
February 4, 2009 at 8:05 am
ok:D
I understand
Thank you for your time and you responses
Unfortunately it is a liitle too late to change my project...though I understand from you that it is a better solution...:D
Again 10x
January 30, 2009 at 3:57 pm
Viewing 15 posts - 46 through 60 (of 107 total)