Viewing 15 posts - 18,316 through 18,330 (of 49,552 total)
Please post the entire procedure, the portion that you posted is full of syntax errors and I'm not sure exactly what you're doing.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 3, 2012 at 2:18 am
Providing the certificate is protected by the database master key and not just password and you have rights on the database master key (which as a sysadmin you do), that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 3, 2012 at 2:17 am
For the record, SQL 2008
DECLARE @WeirdTable TABLE (
ID INT IDENTITY,
Name VARCHAR(150) NOT NULL PRIMARY KEY, -- so cluster
CreateDate DATETIME,
Filler CHAR(100) DEFAULT ''
)
INSERT INTO @WeirdTable (Name, CreateDate)
SELECT name, create_date FROM msdb.sys.tables...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 3, 2012 at 2:13 am
If you have a 20 core server and 1 drive with one data file and SQL is allowed to use all 20 cores, you could potentially get 20 threads doing...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 3, 2012 at 2:03 am
Couple points...
Order by on an insert has never been guaranteed to do anything other than control the order of the identity column if present, top or no top. Select without...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 2, 2012 at 4:02 pm
Nope, that's a complete myth (and an irritatingly persistent one)
The only time there is a specific number of threads writing per file is when SQL is creating a database and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 2, 2012 at 3:47 pm
Easiest way to to append the datetime to the filename.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 1, 2012 at 3:17 pm
CPSPR (6/1/2012)
Homework FTW (I think it's time I invested in an tablet)
I suggest reading the entire book (not because I worked on it, it's just a good book for...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 1, 2012 at 2:29 pm
judyhou (6/1/2012)
Well, I use the studio UI to restore it - why 2005 does not recognize the 2000 backup file?
What do you mean by 'not recognise'?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 1, 2012 at 2:26 pm
No. Don't. You run the risk of writing a good page over the bad block, do nothing to that database.
Try a backup WITH CONTINUE_AFTER_ERROR.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 1, 2012 at 2:07 pm
Backup extension is irrelevant, you can just use the restore GUI to restore the DB, or RESTORE DATABASE T-SQL.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 1, 2012 at 1:30 pm
bleroy (6/1/2012)
but ** bows head, feels small and vulnerable ** I am using .... oracle ...
Then any optimisation recommendations that you would get that assumed you're using SQL 2008...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 1, 2012 at 11:16 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 1, 2012 at 9:35 am
I have some suggestions, but I would really like to see the checkDB output before saying anything.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 1, 2012 at 7:24 am
allymcintosh (6/1/2012)
declare shrinky cursorfor
select name from sysdatabases
where name not in ('master', 'model', 'msdb')
You do know that shrinking TempDB while in use can cause corruption that will require...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 1, 2012 at 5:27 am
Viewing 15 posts - 18,316 through 18,330 (of 49,552 total)