Viewing 15 posts - 6,436 through 6,450 (of 9,244 total)
tut tut really, Books Online details this
Microsoft SQL Server Books Online
A table can have a maximum of 1,000 partitions.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 10, 2011 at 7:14 am
VMWare does page, which edition\version are you using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 10, 2011 at 4:16 am
which VMWare edition are you using?
where do you see the 8GB assignment?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 10, 2011 at 3:52 am
luluwang205205 (10/10/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 10, 2011 at 3:50 am
sqlfriends (10/9/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 10, 2011 at 3:44 am
All you did in part 1 is setup the subnets. Within each machines OS you have to assign an IP in the relevant range. If you need to you could...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2011 at 6:19 pm
Jack Corbett (10/6/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2011 at 1:09 pm
Put the database in emergency mode and run dbcc checkdb with message output first to ascertain exactly what the extent of the damage is. As Gail pointed out, the repair...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2011 at 10:13 am
For this section create 3 new Windows virtual machines.
1 of them requires just 1 virtual NIC connected to the public network.
The other 2 require 3 virtual NICs each. One connected...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2011 at 10:09 am
homebrew01 (9/8/2011)
I liked Idera's tool at my previous job, but now use Redgate backup which is ok too.Most tools offer a free trial so you can try them out.
Isnt the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 8, 2011 at 11:59 pm
Viewing 15 posts - 6,436 through 6,450 (of 9,244 total)