Viewing 15 posts - 12,241 through 12,255 (of 49,552 total)
Depends how you bought the licence.
2008 to 2008 R2 is not a patch, it's not a free download. It's exactly the same in terms of versions as 2005 to 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
July 26, 2013 at 8:36 am
SQL 2005 R2 is a separate version, it's not a patch.
You need to purchase a licence, download the full installation media and run an upgrade.
What you're 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
July 26, 2013 at 4:53 am
curious_sqldba (7/25/2013)
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
July 26, 2013 at 2:20 am
Please post new questions in a new thread. 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
July 26, 2013 at 2:18 am
You can indirectly affect the frequency with the recovery interval setting, but there's not usually a good reason to do so.
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
July 25, 2013 at 6:43 am
Koen Verbeeck (7/25/2013)
GilaMonster (7/25/2013)
Wrote all 5 (for the MCSE), studied from Books Online as I wrote them well before any books were out.
You did the whole SSIS, MDS, DQS thing...
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
July 25, 2013 at 3:23 am
Wrote all 5 (for the MCSE), studied from Books Online as I wrote them well before any books were out.
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
July 25, 2013 at 2:12 am
OracleBoy (7/24/2013)
Hi thk for the reply ,I want to know the size attribute to pools , memory , cache ...
It's all dynamic. Again, what are you trying to find...
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
July 24, 2013 at 11:14 am
OracleBoy (7/24/2013)
1) I want to know the value of options "Partitioning" and "Bit-Mapped" (In oracle , informations are iin v$option table)
There are no such options in SQL Server.
2)...
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
July 24, 2013 at 8:55 am
5+1? That's a very unusual RAID type. Don't think it would be that good for TempDB, 10 would be better, 5+1 would still have the write overhead from the parity...
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
July 24, 2013 at 8:35 am
Rob-350472 (7/24/2013)
This might sound dumb, but what do people actually consider the bug IS?
It's an incorrect results bug, hard to say more. Looks like something in the proc is causing...
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
July 24, 2013 at 3:40 am
Erland Sommarskog (7/24/2013)
I will disagree somewhat with Gail and say, yes, partitioning can be about performance. But in that case there is a price to pay.
It can be (which I...
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
July 24, 2013 at 3:39 am
Chris-475469 (7/24/2013)
As I said previously, I'm aware partitioning isn't for performance. I just know that there is a possibility it MAY help with queries.
If you go and read 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
July 24, 2013 at 2:32 am
Rob-350472 (7/24/2013)
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
July 24, 2013 at 2:20 am
s.kianpoor (7/23/2013)
which subscriber is read only ?
Incorrect.
and when my publisher (main SQL server goes done the subscriber won't work 🙁 )
Incorrect.
As for suggestions, maybe a lot more reading...
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
July 24, 2013 at 2:09 am
Viewing 15 posts - 12,241 through 12,255 (of 49,552 total)