Viewing 15 posts - 6,301 through 6,315 (of 49,552 total)
Nice attitude...
if you had type this in the first place, then i would not have shouted... hehe
Thank you for your First informative reply.
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
March 31, 2015 at 4:24 am
Excuse me??? I don't appreciate being shouted at.
I suggest changing the table definition because you're using a completely inappropriate data type for the column. The text data type is 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
March 31, 2015 at 4:00 am
Why is a column which contains the days of the week a text column which allow for up to 2 billion characters?
Alter the table and set the column to a...
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
March 31, 2015 at 3:44 am
TomThomson (3/30/2015)
And the second comment (to which it was a response, I guess) was appalling
Yeah, that one had me seeing red. While school was a fairly long time ago 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
March 31, 2015 at 3:19 am
To be honest, I'd personally recommend you always run it without the physical_only. Yes, the physical_only is faster and uses less CPU, but it doesn't do the logical checks of...
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
March 31, 2015 at 3:14 am
Neither. (you can't repair_rebuild a database that's suspect)
Restore from a clean backup. Since the DB is in full recovery model, you should have log backups and be able to restore...
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
March 31, 2015 at 3:08 am
Cpt_Picard (3/30/2015)
The OS can only read one data file per core.
This is not true. Any thread on any core can issue an IO request to any file. Please DO 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
March 30, 2015 at 5:06 pm
Cpt_Picard (3/30/2015)
1) Each data file (mdf or ndf) of a database can be read by only one processor core at a time.
False.
Any thread can issue an IO to any file
Since...
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
March 30, 2015 at 5:02 pm
Steve Jones - SSC Editor (3/27/2015)
Late to the gender bias thing as I've been skiing all week. Not to open wounds, but I liked this: http://www.sqlservercentral.com/blogs/databases-infrastructure-security/2015/03/18/women-in-technology/
I think I'm going to...
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
March 30, 2015 at 4:41 pm
GilaMonster (3/30/2015)
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
March 30, 2015 at 10:17 am
The error's right, you can't run anything in Snapshot isolation while DDL changes are happening, and index rebuilds are DDL.
Can you schedule the index changes to some other time?
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
March 30, 2015 at 8:19 am
Iwas Bornready (3/30/2015)
I've never yet learned to terminate a statement with a semi-colon and never failed to start the WITH without it.
Then it's a perfect time to start fixing those...
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
March 30, 2015 at 7:24 am
Why are you trying to have index rebuilds running in snapshot isolation level? What's the point?
From Books Online:
The transaction isolation levels define the type of locks acquired on read operations.
Index...
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
March 30, 2015 at 6:25 am
Spaces or other unprintable characters.
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
March 30, 2015 at 6:18 am
That's not T-SQL. This is a SQL Server site, Microsoft SQL Server. You'll have far better luck on forums dedicated to whatever database engine that code is 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
March 30, 2015 at 6:04 am
Viewing 15 posts - 6,301 through 6,315 (of 49,552 total)