Viewing 15 posts - 9,211 through 9,225 (of 9,241 total)
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
set the recovery model to "bulk logged" during the purge and change back to simple after you have finished deleting data
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 9, 2008 at 7:11 am
you would be wise to furnish sql server with more memory rather than CPU. High CPU count will raise the software costs too 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 9, 2008 at 7:06 am
for SQL2000 try this, it returns any objects not owned by sys or dbo just change it to look for your login (instead of excluding). To catch all DB's wrap...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 8, 2008 at 4:24 am
Viewing 15 posts - 9,211 through 9,225 (of 9,241 total)