Viewing 15 posts - 9,211 through 9,225 (of 9,244 total)
check this info on recovery interval option
http://msdn.microsoft.com/en-us/library/ms191154.aspx
checkpoints occur for a number of reasons
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2008 at 1:14 pm
what are you shrinking data files or log files
SQL server will not shrink past an active portion of the file, if that happens to be near the end of the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2008 at 12:53 pm
or choose script to new query window then close it and save as .sql script
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2008 at 12:41 pm
balbirsinghsodhi (7/11/2008)
or you do not have permission.
balbirsinghsodhi (7/11/2008)
Actually, Some Analytical users are using this database and they create whatever they want.
local temp tables should normally clear up when out of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2008 at 12:39 pm
GilaMonster (7/11/2008)
The related effect of the fill factor is to increase the number of pages in the index.
and consequently the overall file size.
it would be interesting to see what happens...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2008 at 8:35 am
assuming he is seeing a public IP address, my guess is he isn't
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2008 at 6:03 am
thanks Gail, i had a look at that. Re run the script but this time play around with the fill factor...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2008 at 5:59 am
AFAIK the only time its really valid to use a select * is inside a correlated query, dont know if anybody else can add to or confirm this
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2008 at 1:48 am
do you mean reorganise vs drop and create rather than rebuild vs drop and create
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2008 at 1:37 am
wow, never tested it Gail. How would it account for a different fill factor though?
Agree with the last point though, dont shrink!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2008 at 10:24 am
if you are going to shrink, at least do it after the index rebuild as pages will be moved around. If you specified a fill factor of 50 for instance...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2008 at 10:13 am
pound for pound, i have found it quicker to detach copy then re attach databases rather than backup and restore. Also dont forget the microsoft scripts to export your logins...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2008 at 10:07 am
how many servers\databases are we talking?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2008 at 10:04 am
how many characters is the servername currently?
is the SQL server a member server or stand alone server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2008 at 9:33 am
could it be that someone has configured an application\web site to use the SA account? either way assign an obscure password to the account and then disable it. Use the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2008 at 7:01 am
Viewing 15 posts - 9,211 through 9,225 (of 9,244 total)