Viewing 15 posts - 9,241 through 9,255 (of 49,552 total)
To be honest, leave it at Char(5). It's not a huge columns, there isn't a massive waste of space if the data is smaller. Make the column char(5) in 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
April 23, 2014 at 2:21 am
gbritton1 (4/22/2014)
Perhaps the question is more, "What is minimum number of rows threshold where a PK starts to pay off?"
0
Primary key is part of your table design. It's the unique...
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
April 22, 2014 at 1:48 pm
Query, table definitions, index definitions 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
April 22, 2014 at 12:53 pm
Lynn Pettis (4/22/2014)
ChrisM@Work (4/22/2014)
GilaMonster (4/22/2014)
ChrisM@Work (4/22/2014)
Systems here won't...
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
April 22, 2014 at 12:52 pm
ChrisM@Work (4/22/2014)
GilaMonster (4/22/2014)
ChrisM@Work (4/22/2014)
Systems here won't let me...
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
April 22, 2014 at 12:52 pm
ChrisM@Work (4/22/2014)
Systems here won't let me anywhere his...
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
April 22, 2014 at 9:16 am
ChrisM@Work (4/22/2014)
The question I'm asking is here - http://www.sqlservercentral.com/Forums/FindPost1563832.aspx and the query, to save you a few moments, is this:
select KeyInstn, MAX(dateendedstandard) DateEndedStandard
from ObjectViews..InternalOperCBGEstimate
where dateendedstandard <...
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
April 22, 2014 at 7:21 am
ChrisM@Work (4/22/2014)
Does anyone around here know anything about output lists from index seek operators, by any chance?
Maybe, what do you want to know?
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
April 22, 2014 at 7:03 am
I get the rush, but please remember we're all volunteers here.
With just part of the error log, really hard to answer, but the stack dump is a hint
Non-yielding IOCP Listener
IOCP...
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
April 22, 2014 at 6:58 am
Probably is.
Read-only filegroups in simple recovery, not read-write.
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
April 22, 2014 at 6:53 am
Nice error log. And???
Perhaps some background, some details, a question, maybe a please or thank 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
April 22, 2014 at 5:38 am
You can take file and filegroup backups in simple recovery, however unless the file/filegroup is read only, you won't be able to restore them and bring the entire DB online....
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
April 22, 2014 at 5:32 am
The row counts in sys.dm_db_partition_stats and sys.partitions are accurate. The old inaccuracies that sysindexes had don't occur. While the documentation for sys.partitions says 'approximate', the value is in fact accurate.
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
April 21, 2014 at 3:33 pm
It's not about performance, it's about what meets your requirements.
Option 2 will only show the last user who changed the row and won't show what they changed. If you need...
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
April 21, 2014 at 7:24 am
guaro5555 (4/20/2014)
Thanks for jumping in, so how do I fix this issue?
You don't, there's nothing wrong.
The database is part of a Database Mirroring setup. It's a high availability feature...
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
April 20, 2014 at 3:35 pm
Viewing 15 posts - 9,241 through 9,255 (of 49,552 total)