Viewing 15 posts - 7,396 through 7,410 (of 9,241 total)
Ola's scripts are indeed great, Michelle Ufford over at SQLFool[/url] also has a great index maintenance script. Check them both out and go with whichever you prefer!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2010 at 7:04 am
you may upload the report via the report manager website!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2010 at 5:35 am
have you profiled the database to ascertain why data retrieval is slow?
how many rows do the tables hold when performance is slow?
what indexes have been implemented to aid data retrieval?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2010 at 5:32 am
MonsterRocks (11/14/2010)
declare @x2 decimal(38,7)
set @x2 =22225655.95163
set @x1=convert(nvarchar,@x2)
set @x2=convert(decimal(38,7),@x2)
print @x1
its output is 22225655.9
wht shud i pit in scale if i want to display 7 digits...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2010 at 5:21 am
Use the following to pre size the primary data file
alter database MYDB modify file (name = MDFLogicalFileName, size = SizeInMBorGB)
e.g. size = 100MB or size = 100GB
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2010 at 5:10 am
to check the last\current id column value used execute the following query
dbcc checkident('tablename', noreseed)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2010 at 3:45 am
casting binary or varbinary can be unreliable depending on the collation, you would probably want to use sys.fn_varbintohexstr
The best method is detailed at this link and converts to all bases
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2010 at 3:36 am
switch to bulk logged rather than simple recovery, alter index rebuild is minimally logged in this mode too!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 13, 2010 at 12:58 pm
download my guide at this link and check section 4.2 "add a cluster node".
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 13, 2010 at 12:53 pm
If you look closely at the installer you'll see 2 options, one for create a new SQL server failover cluster and one for add a node to a SQL server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 13, 2010 at 10:55 am
with all that's mentioned here, this is why you test before migrating Live. Check with internal devs\vendors whether they support the RDBMS platform or not!
One thing that can issues between...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 13, 2010 at 7:15 am
Keith Hays (11/12/2010)
The process to do this from sp2 is problematic at best.
not problematic, but does require downtime of the other nodes in order to patch the new passive...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 13, 2010 at 7:12 am
Launch the sql server 2008 installer on node b and select add node to a sql server failover cluster.
Step through the wizard and when prompted select the default instance...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 13, 2010 at 4:28 am
hydbadrose (11/12/2010)
but this is sql 2008 servers. will you follow the same method or through the installer?
So why have you posted in the SQL Server 2005 forum then???
No, the install...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 12, 2010 at 4:55 pm
To add node b to the default clustered instance go into add\remove programs on the active node and under the currently installed programs click the SQL Server 2005 entry and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 12, 2010 at 1:20 pm
Viewing 15 posts - 7,396 through 7,410 (of 9,241 total)