Viewing 15 posts - 14,851 through 14,865 (of 19,560 total)
ychen 55059 (4/14/2010)
I'm not familiar with XML. Could you point me to some additional resources so that I can understand...
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
April 14, 2010 at 3:30 pm
WayneS (4/14/2010)
CirquedeSQLeil (4/14/2010)
WayneS (4/14/2010)
Lynn Pettis (4/14/2010)
CirquedeSQLeil (4/14/2010)
Lynn Pettis (4/14/2010)
To the TinD I am going, fun you all can have.It looks like you can come back now.
And I did. Just...
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
April 14, 2010 at 3:08 pm
Lynn Pettis (4/14/2010)
CirquedeSQLeil (4/14/2010)
On the topic of case consistency - please don't ever try Microsoft CRM. It will absolutely drive you bonkers. CRM requires objects be created through...
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
April 14, 2010 at 3:00 pm
Alternatives to the Red Exclamation mark (which historically with MS has meant problems), use F5 or Alt-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
April 14, 2010 at 2:51 pm
WayneS (4/14/2010)
Lynn Pettis (4/14/2010)
CirquedeSQLeil (4/14/2010)
Lynn Pettis (4/14/2010)
To the TinD I am going, fun you all can have.It looks like you can come back now.
And I did. Just waiting 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
April 14, 2010 at 2:48 pm
Yes, size will have an impact on performance - slightly. The larger the database and tables, the more data that may need to be maintained. You should keep...
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
April 14, 2010 at 2:46 pm
The Subquery will also throw an error
The multi-part identifier "#table1.field2" could not be bound.
On the line:
select field1, count(*) line_count from #table2 where field2 > #table1.field2 group by field1
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
April 14, 2010 at 2:43 pm
Guess I was wrong. I interpreted the problem to be that debugging was taking too long and that you wanted to debug.
Glad you found your answer.
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
April 14, 2010 at 2:36 pm
Lynn,
On the topic of case consistency - please don't ever try Microsoft CRM. It will absolutely drive you bonkers. CRM requires objects be created through the GUI. ...
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
April 14, 2010 at 2:23 pm
Lynn Pettis (4/14/2010)
That's why I write all system tables in lower case as well.
I hadn't considered that. Makes sense. I should probably check my...
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
April 14, 2010 at 2:21 pm
WayneS (4/14/2010)
The Green Triangle is to run in Debug mode, the Red Exclamation Point executes the query. You...
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
April 14, 2010 at 2:17 pm
Very interesting. It doesn't do that on mine but apparently it is supposed to be the default behavior.
http://technet.microsoft.com/en-us/library/cc646024.aspx
When debugging transact-sql statements it stops by default on the first line...
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
April 14, 2010 at 2:09 pm
Lynn Pettis (4/14/2010)
CirquedeSQLeil (4/14/2010)
Lynn Pettis (4/14/2010)
To the TinD I am going, fun you all can have.It looks like you can come back now.
And I did. Just waiting now to...
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
April 14, 2010 at 1:47 pm
Typo
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
April 14, 2010 at 1:43 pm
There should have been no need to hit continue on the query.
EDIT: fixed typo.
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
April 14, 2010 at 1:35 pm
Viewing 15 posts - 14,851 through 14,865 (of 19,560 total)