Viewing 15 posts - 9,061 through 9,075 (of 19,560 total)
Try the stuff function:
Select STUFF(
(SELECT ',' + a.columnA AS [text()]
from yourtable a
for xml PATH('')),1,1,'' )
Where columnA=123
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 15, 2011 at 11:18 am
Great topic. And now I have a bit of research and experiment to do.
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 15, 2011 at 10:46 am
Revenant (8/15/2011)
SQLRNNR (8/15/2011)
mulliganstew
Hungry
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 15, 2011 at 10:37 am
Jack Corbett (8/15/2011)
katesl (8/15/2011)
If you have $75000 annual income ethical, no path to grow that income, and one-time opportunity for $1 million bonus not-so-ethical-- what would you do?
Stick at 75k...
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 15, 2011 at 10:36 am
Robert Davis (8/15/2011)
Looks like I missed the fun. I was able to check two answers and got it correct.
Ditto
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 15, 2011 at 10:30 am
GilaMonster (8/15/2011)
Or I can get 4 x...
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 15, 2011 at 10:26 am
GilaMonster (8/15/2011)
All that tech talk's reminded me I need to spec and order my new server.2TB internal storage and 1 TB external sound enough for now?
Double that. Never...
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 15, 2011 at 10:23 am
GilaMonster (8/14/2011)
Akismet - Essential. 99% eliminates spam.
No Self Pings - Doesn't send ping backs to own site (I reference earlier posts often and I don't like that producing trackbacks)
Now...
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 15, 2011 at 10:19 am
mulligan
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 15, 2011 at 10:07 am
I think it does make sense to do 450 after 432.
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 15, 2011 at 10:04 am
You're welcome. Stuff is concatenating the sequence of the hierarchy into a string.
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 15, 2011 at 10:01 am
I recommend finding what is causing all of that growth to occur and fix the process.
1 TB for tempdb is huge.
Here are a couple of articles you should read.
http://www.sqlservercentral.com/articles/Log+growth/69476/
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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 12, 2011 at 5:16 pm
When manually running, this seems to be the norm.
When run from a job, it will run the latest version.
If you know for certain that you no longer need the prior...
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 12, 2011 at 5:14 pm
This will work better for you then.
With CatList (Child, Parent,IDNo, ParentIDNo, Clearance,sortkey) as
(Select ChildCategory, Category, IDNo, ParentIDNo,Clearance
,CAST('.'+CAST(idno AS VARCHAR(Max))+'.' AS VARCHAR(max)) AS sortkey
From Category
where parentidno is null
Union All
Select...
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 12, 2011 at 5:06 pm
Same query i provided will yield these results.
Are you looking for indentation as well? It does not matter what order the data appears in the table - so long...
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 12, 2011 at 4:25 pm
Viewing 15 posts - 9,061 through 9,075 (of 19,560 total)