Viewing 15 posts - 7,846 through 7,860 (of 19,560 total)
jcrawf02 (11/16/2011)
Ninja's_RGR'us (11/16/2011)
Koen Verbeeck (11/16/2011)
Ninja's_RGR'us (11/16/2011)
Koen Verbeeck (11/15/2011)
Ninja's_RGR'us (11/15/2011)
jcrawf02 (11/15/2011)
Hey, I like the condensed version of The Thread...
Same here.
No offense if I forgot anything else. I didn't reread the...
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
November 16, 2011 at 7:59 am
Ninja's_RGR'us (11/16/2011)
crookj (11/16/2011)
SQLRNNR (11/16/2011)
slipslip sliding away...
snow... as in first snow of the year tomorrow.
Don't hold your breath
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
November 16, 2011 at 7:57 am
slip
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
November 16, 2011 at 5:45 am
Also, I would alias the tables internal to the subquery and use those aliases when referencing the columns.
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
November 15, 2011 at 2:40 pm
Does that AD account already have other permissions in the database under the dbo schema?
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
November 15, 2011 at 2:36 pm
Daniel Bowlin (11/15/2011)
SQLRNNR (11/14/2011)
Steve Jones - SSC Editor (11/14/2011)
Done,with travel for the year. 14 events, I think 20 presentations, a long year.
phew
The price of fame
and wanting to live forever
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
November 15, 2011 at 2:35 pm
In your subselect, you are only referencing tables from outside the subselect in your group by clause.
(SELECT SUM(dbo.ART_Exp_Records.Exp_Csm_Value)
FROM dbo.ART_Exp_Records
INNER JOIN dbo.ART_Exp_Sheets
ON dbo.ART_Exp_Records.Exp_Sheet_ID = dbo.ART_Exp_Sheets.Exp_Sheet_ID
GROUP BY dbo.ART_Consortiums.Csm_ID, dbo.ART_Exp_Sheets.Sheet_Year,...
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
November 15, 2011 at 2:33 pm
Krasavita (11/15/2011)
Each GROUP BY expression must contain at least one column that is not an outer reference.
I see that now in your original post - got lost in 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
November 15, 2011 at 2:02 pm
What is the error that you are getting?
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
November 15, 2011 at 1:47 pm
harbor
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
November 15, 2011 at 1:41 pm
It is when you can lay out a table of what the expected results should look like, that often times the solution becomes more apparent for you. It also...
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
November 15, 2011 at 9:54 am
Ninja's_RGR'us (11/15/2011)
Brandie Tarvin (11/15/2011)
Ninja's_RGR'us (11/15/2011)
Brandie Tarvin (11/11/2011)
EEEK! I just sold another story. Happy happy.Now I have to write more.
EDIT: Nevermind. I see you were quoting them for Grant. DOH....
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
November 15, 2011 at 7:43 am
Thanks for pointing out that new article about data files on network shares. That looks interesting and worth a shot.
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
November 15, 2011 at 6:22 am
Grant Fritchey (11/15/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
November 15, 2011 at 6:14 am
Thanks Ron.
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
November 14, 2011 at 8:37 pm
Viewing 15 posts - 7,846 through 7,860 (of 19,560 total)