Viewing 15 posts - 2,251 through 2,265 (of 19,560 total)
Koen Verbeeck (8/14/2014)
Phil Parkin (8/14/2014)
I can't see a way of querying SSISDB directly to get this data. Which makes me wonder where SQL Server has put it!
I asked Matt Masson...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 14, 2014 at 7:42 am
DennisPost (8/14/2014)
I pregrow the files to an appropriate size (sounds like 256GB may need to be considered). But I avoid the multiples of 4GB and will go with 4000MB or...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 14, 2014 at 7:40 am
lmarkum (8/13/2014)
A repair operation got me going again.
Good to hear.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 13, 2014 at 9:35 pm
TomThomson (8/13/2014)
SQLRNNR (8/13/2014)
Why can't sp_rename perform that same metadata update?
Good question. That's something we definitely agree on. sp_rename should update all the metadata. If it did, OBJECT_DEFINITION...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 13, 2014 at 8:48 pm
Evil Kraig F (8/13/2014)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 13, 2014 at 8:45 pm
lmarkum (8/13/2014)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 13, 2014 at 4:44 pm
lmarkum (8/13/2014)
Windows is on the other drive array and was not touched.
Ok, that works for the registry settings. But the permissions for the service accounts on this other array...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 13, 2014 at 4:29 pm
acapone (8/13/2014)
How do I do that from within the SSIS package?
Use a derived column
Try something like the following. Bear in mind that you still have the other transformation in...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 13, 2014 at 3:59 pm
curious_sqldba (8/13/2014)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 13, 2014 at 3:40 pm
I was concerned about the windows accounts and permissions.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 13, 2014 at 3:38 pm
Were all the accounts, permissions and registry settings restored?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 13, 2014 at 3:31 pm
Eirikur Eiriksson (8/13/2014)
demin99 (8/13/2014)
I wanted to find the packages that uses a particular tablename. Is there...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 13, 2014 at 3:25 pm
KoldCoffee (8/13/2014)
i did not think of that. but I tried=Format((Fields!CUL1.Value) * 100,"F2")
and it didn't work.
Multiply by 100 in the source data instead of the format.
It also helps to understand what...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 13, 2014 at 2:53 pm
DennisPost (8/13/2014)
I know Kimberly Tripp[/url] does not recommend log growth using multiples of 4GB increments, but the bug explained by Paul Randal[/url] has nothing to do with crazy VLFs growing.
We...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 13, 2014 at 1:11 pm
Ed Wagner (8/13/2014)
whereisSQL? (8/13/2014)
SQLRNNR (8/13/2014)
nanoo nanoobabbling
Rambling
moment of silence.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 13, 2014 at 1:07 pm
Viewing 15 posts - 2,251 through 2,265 (of 19,560 total)