Viewing 15 posts - 7,396 through 7,410 (of 9,244 total)
phoenixrising1599 (11/14/2010)
I'll have to stand up a 2k instance
That's exactly what I do, any that just can't be moved for whatever reason, I consolidate to a centralised instance. Make 2...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2010 at 3:06 pm
Paul White NZ (11/14/2010)
How is casting binary or varbinary dependent on collation?
Character set conversions! In fact Unicode and instance version may have a bigger effect, I may well be wrong...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2010 at 2:17 pm
presumably your Windows page file occupies the C drive also?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2010 at 12:14 pm
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
Viewing 15 posts - 7,396 through 7,410 (of 9,244 total)