Viewing 15 posts - 7,531 through 7,545 (of 9,241 total)
so what produced this mammoth amount of fle growth and subsequent free space in the first place? Shrinking blindly without knowing the initial cause, it could just grow again!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 3:35 pm
vijay82 (10/16/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 3:30 pm
AWE works in conjunction with PAE which extends the bus from 32 bits to 36 bits. You need PAE support in the OS to use Address Windowing Extensions!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 3:26 pm
turfnsurf4me (10/18/2010)
MSSQLsvc/<machine name>:1433 and with the FQDN
This is incorrect, when running SQL Server under the context of a user account the SPN is bound to that user and not the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 3:14 pm
Duran
It's only SQL Server 2008 that has the shared folder location issue, which itself is fixed in a later CU. SQL Server 2008 R2 as far as I am aware...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 3:06 pm
is this a Windows 2003 or Windows 2008 cluster?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 2:34 pm
which file occupies the most space and has the most free space?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 2:32 pm
Abdul
as already stated you do not need to put the SQL server instance into single user mode to modify the file paths for model and msdb databases. Also, do not...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 2:20 pm
Duran (10/18/2010)
Should I run and add node B now to make it a 2 node cluster, or should I install the other instances (Mulit-Instance) on node A first?
It doesn't...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 2:16 pm
as Brandie states you probably have the client tools install disk only. The CD format has 2 disks and the second disk has client tool install only. The DVD image...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 8:16 am
Doug
Could you confirm you see the following?
➡ splash screen appears when disk autoruns
➡ click install server components and wizard starts
➡ accept EULA and click...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 7:19 am
Jeff Moden (10/18/2010)
Not quite so with your code.
Junk the snippy little aggregate function on the rownum with gaps too 🙂
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 6:01 am
First identify the column(s) that comtain the pertinent data. Once identified the following will suffice!
Select TOP 10 column, column, ...
From mytable
Order by somecolumn desc
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 5:32 am
Not all SQL servers are suitable virtualisation candidates!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2010 at 12:34 am
the question displays a degree of ambiguity but not stupidity!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2010 at 2:03 pm
Viewing 15 posts - 7,531 through 7,545 (of 9,241 total)