Viewing 15 posts - 1,711 through 1,725 (of 6,401 total)
Pretty much hit the nail on the head with that link.
sp_help_revlogin is probably the best tool out to do what you need to do.
November 17, 2015 at 8:59 am
The catalog is filegroup agnostic, its the FTI which is stored on the filegroup, you could have 1 FTC with 20 FTI's and 10 of the FTI's in one filegroup...
November 17, 2015 at 8:49 am
Richie T (11/17/2015)
Same as above but slightly different approachcreate table #test(HID varchar (50))
insert into #test values
('12,3,16'),
('16,10,256'),
('2,150,110,200'),
('5,70,4'),
('2,100,110,150,200,123,159602,1568')
Select *
,charindex(',',reverse(hid)) as last_comma
,LEN(HID) as string_length
,SUBSTRING(reverse(hid),charindex(',',reverse(hid))+1,999) as new_String
,charindex(',',SUBSTRING(reverse(hid),charindex(',',reverse(hid))+1,999)) as new_string_next_Comma
,SUBSTRING(reverse(hid),charindex(',',reverse(hid))+1,charindex(',',SUBSTRING(reverse(hid),charindex(',',reverse(hid))+1,999))-1) As endResult
FROm #test
You need...
November 17, 2015 at 8:37 am
Sounds like someone at the source of the chain who provide you with the zip file of the database backup has changed the logical file names.
November 17, 2015 at 8:17 am
whereisSQL? (11/17/2015)
anthony.green (11/17/2015)
Ed Wagner (11/17/2015)
LeiSteve Jones
editor
Chief
November 17, 2015 at 8:13 am
sandy-808981 (11/17/2015)
November 17, 2015 at 8:05 am
If the current column has none unique values in the range then it can't become the identity unless you manually force the identity_insert value to on.
I would create the table...
November 17, 2015 at 8:03 am
From the CE document
Page 39
Stale Statistics
You may determine that the statistics are outdated. This is not necessarily an issue if the data distribution within the statistics object histogram and density...
November 17, 2015 at 7:56 am
Can the identity be inserted randomly against the existing data? Or does the data have to follow an existing order for the identity?
If the existing column denotes the order,...
November 17, 2015 at 7:34 am
Issue seems to be down to stale statistics on t1.
The cardinality estimator had its first rewrite since SQL 2000 in the 2014 version.
The following document may help, especially the troubleshooting...
November 17, 2015 at 7:19 am
Might be a case of waiting for the ghost cleanup task to kick in, but I wouldn't of thought it would take to long to start the cleanup but depends...
November 17, 2015 at 7:01 am
Sorry I meant your script for the FTC drop and recreate.
Did you add in a new filegroup&file when you recreated the FTC or did you use the existing filegroup&files already...
November 17, 2015 at 6:14 am
Ed Wagner (11/17/2015)
anthony.green (11/17/2015)
Ed Wagner (11/17/2015)
anthony.green (11/17/2015)
Ed Wagner (11/16/2015)
eccentricDBA (11/16/2015)
crookj (11/16/2015)
Ed Wagner (11/16/2015)
ZZartin (11/16/2015)
Luis Cazares (11/16/2015)
DonlSimpson (11/16/2015)
Ed Wagner (11/16/2015)
anthony.green (11/16/2015)
djj (11/16/2015)
anthony.green (11/16/2015)
Ed Wagner (11/16/2015)
SithDark
Chocolate
Bean
Coffee
Java
Jabba
Slave
Drive
Zip
tar
Compression
algorithm
Equation
Complex
Calculation
November 17, 2015 at 6:05 am
Viewing 15 posts - 1,711 through 1,725 (of 6,401 total)