Viewing 15 posts - 12,241 through 12,255 (of 49,558 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,...
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...
July 26, 2013 at 4:53 am
curious_sqldba (7/25/2013)
July 26, 2013 at 2:20 am
Please post new questions in a new thread. Thank you.
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.
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...
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.
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...
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)...
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...
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...
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...
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...
July 24, 2013 at 2:32 am
Rob-350472 (7/24/2013)
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...
July 24, 2013 at 2:09 am
Viewing 15 posts - 12,241 through 12,255 (of 49,558 total)