Viewing 15 posts - 4,786 through 4,800 (of 9,241 total)
Marios Philippopoulos (10/13/2012)
I found out that this data file contains data from a text column.Could this be the reason I am having trouble shrinking the file?
why don't you re run...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 13, 2012 at 12:17 pm
sej2008 (10/13/2012)
I am log shipping from pc1 to pc2 as
an pc1\administrator and having same password on the machine still...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 13, 2012 at 12:06 pm
Technically, with contained databases in 2012, you are bypassing connections through the server as you are authenticated directly by the user database.
Under Oracle an instance is a database, its an...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2012 at 11:01 am
greg.huxley (10/12/2012)
I have two physical servers, one running SQL Server 2005 and one SQL Server 2012. I have been tasked with migrating the 2005 databases to 2012 using the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2012 at 10:56 am
kevaburg (10/12/2012)
How do I find out how much of that datafile is actually filled with data and how much is empty and reserved for use using SQL-based queries
Run this per...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2012 at 8:05 am
ericwenger1 (10/12/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2012 at 7:25 am
oh for sure, I don't doubt that. But, all the same, these things can and do happen
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2012 at 5:51 am
GilaMonster (10/12/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2012 at 4:16 am
Paul Clark-418949 (10/12/2012)
For most of our VM's it is just 1 aggregate as you are correct NetApp best practice....
But I wanted the separate RAID Groups for the SQL Volumes (I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2012 at 3:37 am
GilaMonster (10/11/2012)
I don't recommend enabling large pages, it can have some effects at startup and it doesn't usually help much, if at all
+ 1
When you enable large pages SQL Server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2012 at 2:30 am
Paul Clark-418949 (10/12/2012)
Perry Whittle (10/11/2012)
Paul Clark-418949 (10/11/2012)
D: Drive - SQL Installation - (Filer02 - Volume 2)
F: Drive - Page File -...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2012 at 2:22 am
runal_jagtap (10/11/2012)
thanks for providing the answer 🙂
Currently we have 5 servers...
For example..
1 server have 20 databases almost 20GB each.. now the tempdb files & user datafiles & log files...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2012 at 11:43 pm
Paul Clark-418949 (10/11/2012)
D: Drive - SQL Installation - (Filer02 - Volume 2)
F: Drive - Page File - (Filer01 - Volume 3)
G:...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2012 at 11:39 pm
Ok no problem
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2012 at 3:53 pm
Lazy DBA (10/11/2012)
Other option was to find the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2012 at 2:53 pm
Viewing 15 posts - 4,786 through 4,800 (of 9,241 total)