Viewing 15 posts - 6,436 through 6,450 (of 9,253 total)
i suspect it may someone who works for the company 😉
October 10, 2011 at 10:11 am
MysteryJimbo (10/10/2011)
1,000 only equates to approx 3 years of a daily partition. A long time if youre partitioning in months though! 😀
agreed, it all depends on the definition...
October 10, 2011 at 9:11 am
good catch, worth pointing out that 1000 is still the standard theoretical out of the box though.
October 10, 2011 at 8:30 am
Dev @ +91 973 913 6683 (10/10/2011)
Has anyone burnt his hands in such practice?
No, because we test new CUs or SPs and check what effect they have on the...
October 10, 2011 at 8:20 am
Dev @ +91 973 913 6683 (10/10/2011)
What about the existing implementations?
That's exactly what I am referring too!!
October 10, 2011 at 8:14 am
Dev @ +91 973 913 6683 (10/10/2011)
Perry Whittle (10/10/2011)
they may change at any pointIsn’t it a reason to worry?
no, as Microsoft advise hwne using any of these procedures be...
October 10, 2011 at 7:51 am
tut tut really, Books Online details this
Microsoft SQL Server Books Online
A table can have a maximum of 1,000 partitions.
October 10, 2011 at 7:43 am
take xp_delete_file. This proc is undocumented but yet is called by maintenance plans to prune aging text\backup files.
It seems to me the undocumented procedures are generally the ones that SQL...
October 10, 2011 at 7:40 am
parissa_bakhshi (10/10/2011)
So in either way, if you use CNAME or A recore, you shall change the orriginal A record IP address.
this is incorrect.
If i have a DNS host...
October 10, 2011 at 7:34 am
derekr 43208 (10/10/2011)
Hi GuysI have SQL 2008 enterprise Sp2 installed on Windows 2008 enterprise.
This is a single node cluster
What is the process of adding a second node to this cluster?
Has...
October 10, 2011 at 7:14 am
VMWare does page, which edition\version are you using?
October 10, 2011 at 6:48 am
In SQL Server 2005, all tables are essentially partitioned by default, they all exist in a default first partition (check the tables sys.partitions and sys.allocation_units). You will need to examine...
October 10, 2011 at 5:04 am
praveen_vejandla (10/10/2011)
We would like to streamline access to production SQL Servers such that non-DBA users will not have sysadmin privileges
that is the recommended practice.
praveen_vejandla (10/10/2011)
October 10, 2011 at 4:16 am
which VMWare edition are you using?
where do you see the 8GB assignment?
October 10, 2011 at 3:52 am
luluwang205205 (10/10/2011)
October 10, 2011 at 3:50 am
Viewing 15 posts - 6,436 through 6,450 (of 9,253 total)