Viewing 15 posts - 26,596 through 26,610 (of 49,552 total)
Please don't cross post. It just wastes people's time and fragments replies
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1096116-145-1.aspx
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, 2011 at 2:08 am
DROP INDEX ....
CREATE UNIQUE INDEX ...
or
CREATE UNIQUE INDEX ....
WITH DROP_EXISTING
You cannot alter an index to add a column
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, 2011 at 2:06 am
If you want help in tuning, please post execution plans, query, table definition, index definitions. See 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
April 20, 2011 at 2:04 am
Posting a new question on an old thread often results in no answers, as people looking to help out and answer questions assume that a thread with 15+ replies 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
April 20, 2011 at 2:01 am
jasonmorris (4/20/2011)
Developers have been locked back in their cupboard for the rest of the year.
😀 :hehe:
Just make sure you slip some coffee to them every now and again, otherwise 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 20, 2011 at 1:54 am
Please note: year old thread.
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 19, 2011 at 11:47 pm
Between the diff and the failed log someone either ran BACKUP LOG ... TRUNCATE_ONLY or switched the DBs to simple recovery and back to full, thus breaking the log chain.
You'll...
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 19, 2011 at 11:36 pm
Once those have been fixed, run a checkDB and post any results.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
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 19, 2011 at 11:21 pm
Craig Farrell (4/19/2011)
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 19, 2011 at 4:25 pm
First you need to add a computed column to the table, expression being RIGHT(LoanID,2). Then you can index that computed column.
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 19, 2011 at 3:56 pm
opc.three (4/19/2011)
I just stumbled into a really big topic.
Welcome to memory management. Please check your sanity in at the door.
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 19, 2011 at 3:52 pm
OCTom (4/19/2011)
That way prospective employers or clients can't "get you" on anything.
Do you want to work for a company that's so draconian about what you do in your free 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
April 19, 2011 at 3:29 pm
If that was greek, may I suggest downloading and watching this: http://channel9.msdn.com/Events/PDC/PDC10/CD01 and this http://channel9.msdn.com/Events/PDC/PDC10/CD02
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 19, 2011 at 1:25 pm
It's not something you need to control in 64-bit.
It has nothing to do with the amount of physical memory, it's a non-reserved portion of the virtual address space of 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 19, 2011 at 12:56 pm
In 32-bit, the mem-to-leave is a piece of the virtual address space (2GB) left for non-paged memory. SQL reserves it before it allocates the buffer pool, then frees it 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
April 19, 2011 at 12:24 pm
Viewing 15 posts - 26,596 through 26,610 (of 49,552 total)