Viewing 15 posts - 8,896 through 8,910 (of 19,560 total)
Ninja's_RGR'us (8/25/2011)
SQLRNNR (8/25/2011)
Steve Jones - SSC Editor (8/25/2011)
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 25, 2011 at 10:01 am
GilaMonster (8/25/2011)
SQLRNNR (8/25/2011)
Grant Fritchey (8/25/2011)
... and Sharepoint and the business, and some PowerShell, and search engines, and a little NoSQL and...
Really, this is a public forum... We should refrain...
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 25, 2011 at 9:59 am
Thanks for the question.
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 25, 2011 at 9:52 am
Steve Jones - SSC Editor (8/25/2011)
Leave it...
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 25, 2011 at 9:48 am
Ninja's_RGR'us (8/25/2011)
Brandie Tarvin (8/25/2011)
Tom.Thomson (8/25/2011)
I saw this in an SS Central topic, and responded appropriately - I hope. If anyone thionks I was inappropriately heavy, let me know.
The first...
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 25, 2011 at 9:44 am
Ninja's_RGR'us (8/25/2011)
GilaMonster (8/25/2011)
Tom.Thomson (8/25/2011)
I saw this in an SS Central topic, and responded appropriately - I hope. If anyone thionks I was inappropriately heavy, let me know.
Grrr. What a...
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 25, 2011 at 9:42 am
Grant Fritchey (8/25/2011)
... and Sharepoint and the business, and some PowerShell, and search engines, and a little NoSQL and...
Really, this is a public forum... We should refrain from such...
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 25, 2011 at 9:41 am
Ninja's_RGR'us (8/25/2011)
GilaMonster (8/25/2011)
Saga... (8/25/2011)
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 25, 2011 at 9:40 am
Fal (8/24/2011)
Jeff Moden (8/24/2011)
Fal (8/24/2011)
Jeff Moden (8/23/2011)
Stefan Krzywicki (8/23/2011)
Earthquake in CO yesterday and now one in VA that I felt all the way in Boston.
Hope everyone in the affected area...
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 25, 2011 at 9:34 am
you're welcome
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 25, 2011 at 9:28 am
LutzM (8/24/2011)
I think the confusing part is reusing the f00 column name. In the original table it holds the total per D_SBU, whereas the expected output holds the splitted data.
Nice...
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 24, 2011 at 3:10 pm
Perry Whittle (8/24/2011)
in truth, to SSRS, they are system databases. They hold metadata and temporary storage (sort of like a TEMPDB) used by the reporting services instance(s)
That is true -...
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 24, 2011 at 2:56 pm
Do you have the information on the values that each bit value represents?
Without it, you can't break that data up accurately.
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 24, 2011 at 2:44 pm
Looking at the data again, it looks like they have concatenated the two fields using bit operations.
Do you have lookup tables that contain the values for those bits?
Specifically f00 and...
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 24, 2011 at 2:29 pm
What format are you receiving this data?
xml, csv, other?
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 24, 2011 at 2:26 pm
Viewing 15 posts - 8,896 through 8,910 (of 19,560 total)