Viewing 15 posts - 4,081 through 4,095 (of 7,164 total)
Jeff Moden (5/11/2012)
Do you have any performance metrics for this, Orlando?
I do not, but I would be happy to mock up some test data and run some tests. I used...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 11, 2012 at 8:53 pm
capn.hector (5/11/2012)
opc.three (5/11/2012)
Could be. I did not think SHRINKFILE was sunject to the 'initial size' issue though.
i believe only when used with CREATE DATABASE. all the DB's we created...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 11, 2012 at 8:40 pm
Could be. I did not think SHRINKFILE was sunject to the 'initial size' issue though.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 11, 2012 at 5:53 pm
OK, I am with you now. I would run a Trace to see what SSMS is doing. My guess is SSMS does a SHRINKFILE w/ NOTRUNCATE first to bring all...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 11, 2012 at 5:35 pm
In a database-level audit I think your options are limited. All sysadmins are mapped into the DB as dbo.
You could run a Trace and filter on the SessionLoginName. This is...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 11, 2012 at 4:49 pm
capn.hector (5/11/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 11, 2012 at 4:15 pm
annastassia1935 (5/11/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 11, 2012 at 2:47 pm
CptCrusty1 (5/11/2012)
opc.three (5/11/2012)
CptCrusty1 (5/11/2012)
:rolleyes: oh jeeeeez.....Too basic for you?
Nah... it was the Texas comment. You'd really love it if you knew that I grew up in Southern CA....
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 11, 2012 at 1:57 pm
CptCrusty1 (5/11/2012)
:rolleyes: oh jeeeeez.....
Too basic for you?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 11, 2012 at 1:45 pm
CptCrusty1 (5/11/2012)
Since I have ya'll's attention. Can ya'll recomment a good starting point for more advanced SSIS schtuff? Reading material, things to try,...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 11, 2012 at 1:38 pm
CptCrusty1 (5/11/2012)
Yes... That was a thank you... just a goofy one which is normal for me... 😉
Welcome to SSC!
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 11, 2012 at 1:21 pm
CptCrusty1 (5/11/2012)
CptCrusty1 (5/11/2012)
I try... I try... yet, it is a skill I have....
---Although, don't think I'm ungrateful... I'm always grateful to those with more knowledge, experience, or...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 11, 2012 at 1:12 pm
Wow, lazy, sarcastic and ungrateful. Nice combo Cap'n 😛
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 11, 2012 at 1:08 pm
.NET has this functionality built-in and does a pretty good job. It may not be exactly what you want, but I thought it was worth mentioning. Here is a SQLCLR...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 11, 2012 at 1:05 pm
CptCrusty1 (5/11/2012)
Elliott Whitlow (5/11/2012)
Even if it were I have to say I don't think its a good idea. Just create a table in...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 11, 2012 at 12:55 pm
Viewing 15 posts - 4,081 through 4,095 (of 7,164 total)