Viewing 15 posts - 26,086 through 26,100 (of 49,552 total)
jmerrill 28016 (5/16/2011)
Am I crazy to think that anything that causes a "suspect database" is a hardware problem or a SQL Server bug?
Yup. Pretty much. Most likely hardware (IO)...
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
May 16, 2011 at 11:52 am
Brandie Tarvin (5/16/2011)
Ray K (5/16/2011)
When I tried calling the SP, I got the 'Must declare the scalar variable "@Result".' message.
Declare @Result int;
Execute TestProc 'ID','Email', @Result output;
That's how you call an...
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
May 16, 2011 at 11:31 am
SQLRNNR (5/16/2011)
Back to alphabet soup. I love the alphabet soup when the certification is mis-spelled (e.g. MCSE becomes MSCE or MCDBA becomes something like MCSDBA)
Linky? Please?
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
May 16, 2011 at 10:02 am
Errr... Works for me as you have it. (I removed the rest of the variables & parameters for simplicity)
DECLARE @Result int
declare @sql nvarchar(1024)
...
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
May 16, 2011 at 10:00 am
Errr, right up close to the top of the script....
CREATE TABLE dbo.dba_indexDefragExclusion
(
databaseID INT ...
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
May 16, 2011 at 9:53 am
Ninja's_RGR'us (5/16/2011)
GilaMonster (5/16/2011)
rowversion = timestamp, just different names for the same data type. Timestamp is deprecated, but SSMS still uses it (go figure)
Does MS know about this too??? Is...
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
May 16, 2011 at 9:46 am
rowversion = timestamp, just different names for the same data type. One is just the alias of the other. Timestamp is deprecated, but SSMS still uses it (go figure), but...
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
May 16, 2011 at 9:32 am
colin.Leversuch-Roberts (5/16/2011)
it's quite interesting as to what sometimes seems quite simple often isn't.
Yeah, this is a Hard problem with SQL functions. With regex it would be trivial, but...
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
May 16, 2011 at 9:27 am
jpSQLDude (5/16/2011)
Ninja's_RGR'us (5/16/2011)
Well it doesn't <completely> break it. that's why I said I preffer to have that run with full backups as first and last steps.
I'm pretty sure the...
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
May 16, 2011 at 9:13 am
Ninja's_RGR'us (5/16/2011)
GO
Create Table dbo.Maintenance
(
maintName varchar(225) NOT NULL,
maintid int NOT NULL,
CONSTRAINT Only_Characters
CHECK (maintName LIKE '%[A-Z ]%')
)
GO
INSERT into dbo.Maintenance (maintName, maintid) VALUES('abcdefghijklmnopqrstuvwxyz', 1)
INSERT into dbo.Maintenance (maintName, maintid) VALUES('1', 1)
SELECT...
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
May 16, 2011 at 9:07 am
You have a double negative problem.
Your constraint currently reads Where column NOT like NON-Numeric characters, ie must be like numeric characters only. The ^ is the second negation.
Maybe this?
Create Table...
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
May 16, 2011 at 9:05 am
http://sqlfool.com/2010/04/index-defrag-script-v4-0/
Why roll your own when someone's done it for you?
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
May 16, 2011 at 8:52 am
'1' can be implicitly converted to integer and inserts fine. '12K34' is not and will not.
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
May 16, 2011 at 8:48 am
Ninja's_RGR'us (5/16/2011)
Tx Gail. I just ran the GUI and copied the script into the job after a few alterations. I'll let MS know :-).
SSMS writes crap code. I...
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
May 16, 2011 at 8:46 am
Depends. It's not just the blocking, it's that SQL doesn't bother taking any locks at all. Gone is the time required to ask for locks, overhead of lock memory, checking...
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
May 16, 2011 at 8:42 am
Viewing 15 posts - 26,086 through 26,100 (of 49,552 total)