Viewing 15 posts - 17,791 through 17,805 (of 19,560 total)
We use vmware and Server 2003.
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
January 27, 2010 at 9:18 pm
WayneS (1/27/2010)
CirquedeSQLeil (1/27/2010)
Jeff Moden (1/27/2010)
Alvin Ramard (1/27/2010)
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
January 27, 2010 at 9:14 pm
Paul White (1/27/2010)
CirquedeSQLeil (1/27/2010)
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
January 27, 2010 at 9:10 pm
Jeffrey Williams-493691 (1/27/2010)
How about this:SELECT *
FROM #s
WHERE name collate Latin1_General_BIN = upper([name])
Jeff is correct on this. This method works quite nicely for your requirements.
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
January 27, 2010 at 6:38 pm
Yes. We are currently running some SQL 2008 instances in VM.
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
January 27, 2010 at 6:29 pm
I need a couple of volunteers if any are willing and have some spare time.
I am wrapping up an article and would like somebody else to review it if possible.
Thanks...
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
January 27, 2010 at 5:38 pm
Are you asking if it is supported by Microsoft?
Or
Can it be done?
or
Does Microsoft recommend 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
January 27, 2010 at 5:31 pm
lptech (1/27/2010)
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
January 27, 2010 at 5:29 pm
There are already a couple of solutions proposed that use a CTE. I would recommend picking a CTE solution.
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
January 27, 2010 at 5:23 pm
Jeff Moden (1/27/2010)
Alvin Ramard (1/27/2010)
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
January 27, 2010 at 4:56 pm
Alvin Ramard (1/27/2010)
I'm thinking that I need to get a "desktop replacement" laptop and then turn my desktop into a home server .
i saw a vaio with 8GB ram, 500GB...
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
January 27, 2010 at 3:38 pm
In that case then....
I personally am looking at the Vaio. Unless there is a really good laptop with minimum 4gb that has about the same price tag as 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
January 27, 2010 at 3:24 pm
Alvin Ramard (1/27/2010)
Steve Jones - Editor (1/27/2010)
Alvin Ramard (1/27/2010)
It's not like I'm asking them to fix my laptop. 😀
Yikes, ouch, hey. Still not fixed. Ordering a new one 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
January 27, 2010 at 3:15 pm
Alvin Ramard (1/27/2010)
Someone eyes have been opened. Progress is being made. 🙂
...
Behold the power of Grant 😀
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
January 27, 2010 at 2:44 pm
Lynn Pettis (1/27/2010)
Alvin Ramard (1/27/2010)
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
January 27, 2010 at 12:55 pm
Viewing 15 posts - 17,791 through 17,805 (of 19,560 total)