Viewing 15 posts - 18,706 through 18,720 (of 49,552 total)
Schadenfreude-Mei (4/30/2012)
SP1 was released at the same time as RTM so even MS knew RTM was cack.
SQL 2005 RTM was released November 2005
SQL 2005 SP1 was released March 2006
The main...
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 30, 2012 at 5:25 am
inf1154 (4/30/2012)
i try to make that when i write for example in my 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 30, 2012 at 4:58 am
krishnaprasad14 (4/30/2012)
Thank you very much for all .....Issue is resolved and Now This DB is up and running .........
http://www.sqlskills.com/BLOGS/PAUL/post/Do-transactions-rollback-when-DBCC-CHECKDB-runs.aspx
That's talking about the snapshot creation upon running a normal checkDB. If...
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 30, 2012 at 4:52 am
PaulB-TheOneAndOnly (4/29/2012)
eric.lyons (4/26/2012)
I wince every time I hear someone use the words "cloud computing".This is marketing hype in line with the "pet rock."
Hope you are trying crack a joke -...
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 29, 2012 at 3:27 pm
Tara-1044200 (4/29/2012)
I am getting the errorMsg 536, Level 16, State 5, Line 1
Invalid length parameter passed to the SUBSTRING function.
Because you're trying to remove more characters than the string has....
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 29, 2012 at 2:18 pm
Tara-1044200 (4/29/2012)
Not sure if understood you guys correctly but are you saying that i can remove last 12 charcters using LEN function?
Sure you can. But you need to ensure that...
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 29, 2012 at 2:16 pm
Rebuild the clustered index.
You could have mostly empty pages and/or empty pages in allocated dedicated extents.
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 29, 2012 at 11:37 am
If it's ordering 1, 10, 11, 12, etc, than that column is not an integer, it's a string. That's string ordering.
Convert the column to integer (which, if it's numeric 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
April 29, 2012 at 9:17 am
Partition number is literally just an incremental ID of partitions in a table. If a table is not partitioned, that will be 1. If the table is partitioned then 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
April 29, 2012 at 9:13 am
What's the default size of the file?
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 29, 2012 at 7:01 am
Let's take a step back for a moment.
The grant statement that you ran grants execute rights to all functions and stored procedures in the database, that's all it does. Now...
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 29, 2012 at 6:41 am
No
A full database backup is a complete backup of the entire database. A transaction log backup contains the log records since the last transaction log backup.
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 29, 2012 at 5:35 am
Every table consists of at least one partition, every index consists of at least one partition. Hence 4 indexes mean 4 different partition IDs. It's just a number, like object...
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 28, 2012 at 11:54 am
Jeff Moden (4/28/2012)
GilaMonster (4/28/2012)
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 28, 2012 at 10:56 am
MadTester (4/28/2012)
I have heard rumours from my peers that defragging the MDF will in some way logically fragment the indexes so that it would necessitate another index rebuild.
Err, no.
mdf file...
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 28, 2012 at 8:45 am
Viewing 15 posts - 18,706 through 18,720 (of 49,552 total)