Viewing 15 posts - 676 through 690 (of 1,319 total)
Another "it depends". How large is the maintenance window? By not doing all tables, only focusing on the larger ones, are you seeing peformance degradation? The are some scripts on...
-- You can't be late until you show up.
May 5, 2009 at 9:05 am
ichbinraj (5/5/2009)
Thanks guys ,Is It best to put FILLFACTOR = 80 ?
ichbinraj
One of those "it depends" answers. How much data is being loaded into the tables? If a...
-- You can't be late until you show up.
May 5, 2009 at 8:43 am
Sounds like a good plan - after hours and such. How many indexes/rows are associated with the table? Have you done this in a dev environment to gauge an estimate...
-- You can't be late until you show up.
May 5, 2009 at 8:03 am
goparaju.chandu (5/5/2009)
my d:\\ drive was full. i wnt to some space to D:\\ .
What else resides on this drive? Can additional hard rives be added to the partition? Can you...
-- You can't be late until you show up.
May 5, 2009 at 7:14 am
This should give you a start.
Create Procedure SQL_ServerROLES as
Set nocount on
-- Author: Saleem Hakani
-- Date: Oct 15th 2007
-- Description: Below script will query SysLogins to find out which...
-- You can't be late until you show up.
May 4, 2009 at 1:53 pm
You can use the DTS Import/Export Wizard. See BOL. Really simple to use.
-- You can't be late until you show up.
May 4, 2009 at 1:27 pm
Thanks Mike. Job monitor is exactly what I was looking for (sure beats clicking on each job!). I knew I was overlooking something simple. And I haven't even gotten into...
-- You can't be late until you show up.
April 30, 2009 at 1:56 pm
While trying not to reveal much about my age - myself and 3 buddies climbed into a car a drove to the theater complex that was the biggest in Chicago...
-- You can't be late until you show up.
April 30, 2009 at 11:46 am
Either increase the size of the fileds on the table or shorten the amount of data to fit your current size. One question - why are you adding first name...
-- You can't be late until you show up.
April 30, 2009 at 8:08 am
Lynn Pettis (4/28/2009)
The desert...
-- You can't be late until you show up.
April 29, 2009 at 6:14 am
jspatz (4/27/2009)
" failed with the following error: "The transaction log for database 'DAReporting' is full.
Pretty much says it all. Either backup the log more frequently, especially during the reorg, or...
-- You can't be late until you show up.
April 27, 2009 at 10:05 am
David Burrows (4/27/2009)
their were 102 stones in her gallbladder
YOWZA!
Get well soon Barry! I'm sure all will go well.
-- You can't be late until you show up.
April 27, 2009 at 6:59 am
If I rebuild indexes, doesn't that also update my statisics like SQL 2000? Did not know about WITH DATA_PURITY but just googled it to see what it does. One other...
-- You can't be late until you show up.
April 24, 2009 at 3:03 pm
OS is windows 2003 EE, SQL is x86 SE, awe-enabled. So leaving the pagefile at 2GB appears to be fine? Our network guys want to push the pagefile to 8GB,...
-- You can't be late until you show up.
April 24, 2009 at 2:12 pm
Jack Corbett (4/23/2009)
tosscrosby (4/23/2009)
wouldn't it be four-part naming convention?i.e. SET @from = N'.database_name.schema_name.table_name Where criteria'
Yup. Nice catch. I totally braincramped on that one.
First time for everything I...
-- You can't be late until you show up.
April 23, 2009 at 12:16 pm
Viewing 15 posts - 676 through 690 (of 1,319 total)