Viewing 15 posts - 29,176 through 29,190 (of 49,552 total)
Have you tried google? There are a large number of blog posts written on that exact topic.
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
November 26, 2010 at 12:09 pm
WayneS (11/26/2010)
And the funny thing is... according to all that have met him in person, he is quite a personable guy
Absolutely. Very polite, very soft spoken.
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
November 26, 2010 at 7:33 am
There's no ALTER option to change a column name (see the spec for Alter Table in Books Online to see what options it has). To rename a column, you use...
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
November 25, 2010 at 11:09 pm
CirquedeSQLeil (11/25/2010)
LutzM (11/25/2010)
-> If you need to use a CTE, reference it...
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
November 25, 2010 at 1:28 pm
And you're also fine with possibly missing rows or reading rows twice?
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
November 25, 2010 at 8:19 am
Before answering that, I have one for you. Do you know what nolock does?
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
November 25, 2010 at 7:58 am
reymon26 (11/25/2010)
what i mean is that , are ther other new functions or function that works just like the use of a coalesce?
Why? What are you trying to do?
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
November 25, 2010 at 6:40 am
No and no. Coalesce has not been replaced, there's no new keyword for it. It's still there and usable in SQL 2005/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
November 25, 2010 at 5:44 am
You've got some very severe, irreparable errors in this database. Restore from your last good backup.
Also do some checks of the IO subsystem on this machine. Something caused a lot...
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
November 25, 2010 at 4:06 am
You'll probably get better and quicker answers to mySQL questions on the MySQL forums. forums.mysql.com I believe, also over at http://www.dbforums.com
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
November 24, 2010 at 1:53 pm
Backups were all setup on install and never touched again until I get around to them.
Do you know if the backups are restorable in case of a disaster?
Indexing is something...
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
November 24, 2010 at 1:01 pm
As I said, I think it would take a lot of knowledge of the database, the queries and the data to be able to say whether an index should be...
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
November 24, 2010 at 12:53 pm
YSLGuru (11/24/2010)
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
November 24, 2010 at 12:48 pm
Physical reads are reads from disk. Logical reads are reads from memory. If a page is read 10 times, it's counted 10 times.
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
November 24, 2010 at 9:50 am
Alvin Ramard (11/24/2010)
Just heard IT supervisor say it's 110 degrees in the server room. Glad I don't have anything to do with server admin.
This may be a good 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
November 24, 2010 at 9:23 am
Viewing 15 posts - 29,176 through 29,190 (of 49,552 total)