Viewing 15 posts - 9,586 through 9,600 (of 19,560 total)
Thanks for the question - too bad I missed all the fun with the backwards 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
June 29, 2011 at 11:43 am
So from SSMS you can query the table and return results, but when trying to "Open" the table you don't get results.
Do you get an error?
Are you trying to perform...
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
June 28, 2011 at 4:36 pm
GilaMonster (6/28/2011)
No, I'm not that interested in getting involved in setting 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
June 28, 2011 at 3:22 pm
GilaMonster (6/28/2011)
SQLRNNR (6/28/2011)
You should have written the one for 450 - IMHO it needs a revamp to correct some flaws.:-D
I have. For 2008 I've written 432, 433, 450 and 451....
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
June 28, 2011 at 3:08 pm
Logic sounds good.
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
June 28, 2011 at 3:03 pm
GilaMonster (6/28/2011)
Rich Yarger (6/28/2011)
No practice exams for the Denali TS and ITP certs??? I had better get my 2008 creds done soon.
Err, what???
The Denali exams likely won't be out...
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
June 28, 2011 at 2:59 pm
adocity (6/26/2011)
I am trying to scale up my database from Access to SQL Server 2005.
When I run my 'Insert' statements I can not see the record in the table...
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
June 28, 2011 at 1:52 pm
Koen Verbeeck (6/28/2011)
Chad Crawford (6/28/2011)
Wahoo! My users group just scheduled me to speak in August. Let the stress begin.... 😀
Congratulations.
I did my very first technical session last...
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
June 28, 2011 at 1:50 pm
There are many older apps that I prefer over newer apps due to functionality (change or loss). If the app works solid, then why not use it still?
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
June 28, 2011 at 1:44 pm
Chad Crawford (6/28/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
June 28, 2011 at 1:15 pm
Chad Crawford (6/28/2011)
Wahoo! My users group just scheduled me to speak in August. Let the stress begin.... 😀
SLC or Provo?
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
June 28, 2011 at 11:10 am
Ninja's_RGR'us (6/28/2011)
(PatientId, OperationId, OperationDate (for order by))
Then your query simply becomes
Select * from PatientOperations where Operation IN (Ids 1,2,3,4,5)
Join back to base table(s) to get the rest of...
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
June 28, 2011 at 11:09 am
Jeff Moden (6/26/2011)
For your final question, I NEVER take anything...
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
June 28, 2011 at 10:57 am
By having a normalized structure, your query would be greatly simplified.
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
June 28, 2011 at 10:14 am
grenouille
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
June 28, 2011 at 9:59 am
Viewing 15 posts - 9,586 through 9,600 (of 19,560 total)