Viewing 15 posts - 4,576 through 4,590 (of 14,953 total)
I suspect this will get you closer to what you need:
SELECT ae.DM_AuditNurseID AS 'Nurse_Code',
an.NL_NurseFirst 'Nurse_First_Name',
...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 18, 2011 at 1:04 pm
Why are you using Group By in this? I don't see any aggregate functions (Min, Max, Avg, etc.) in the Select clause.
Move the Top 25 part to the Select,...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 18, 2011 at 11:47 am
Don't use SSMS for that. Don't your databases have applications or web pages as a front-end and presentation layer?
If you really need to bypass all of the usual layers...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 18, 2011 at 11:41 am
Take a look at the "LIKE" operator in the T-SQL string functions section of MSDN or Books Online. It'll do that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 18, 2011 at 11:37 am
Saying that these tools are useless for a "good DBA" is like saying a good carpenter shouldn't need a tablesaw, since you can do everything you need to do with...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 18, 2011 at 11:36 am
thbaig1 (3/18/2011)
I have used profiler. with all performance option checked also deadlock and some other options
Then Profiler can open the trace file for you.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 18, 2011 at 7:00 am
I have found that Confio Ignite is very useful for tracking down the exact SQL statements that are causing the most performance issues on a server.
Other than that, I really...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 18, 2011 at 6:59 am
thbaig1 (3/18/2011)
thanks Lowell, but it is not giving required results.where can i find execution plan of queries?
How did you create the trace? Did you use Profiler, or did you...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 18, 2011 at 6:53 am
Tech greenie (3/17/2011)
...The text is variable and I cannot tell what the lines look like when they are typed....
I have to admit, this part of your post kind of threw...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 18, 2011 at 6:50 am
If you have all the data in each site, then that handles both your failover and your "person A in location C" issue.
The only thing I can think of that...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 18, 2011 at 6:46 am
The only thing I can think of with files that size would be compress, copy to a big portable drive (or more than one), and move it that way. ...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 18, 2011 at 6:40 am
If the string doesn't have the delimiter in it, you'll get a LEFT(string, 0) or LEFT(string, -1) essentially, and that is an invalid value for the LEFT function, hence the...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 17, 2011 at 2:42 pm
CirquedeSQLeil (3/17/2011)
Craig Farrell (3/17/2011)
CirquedeSQLeil (3/17/2011)
Brandie Tarvin (3/17/2011)
Craig Farrell (3/17/2011)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 17, 2011 at 11:54 am
Craig Farrell (3/17/2011)
...they get ahead of themselves. 🙂Annnnd, now I have an image of sheep storming the castle. I wonder if they fit their armor before or after sheerings...
Time...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 17, 2011 at 11:46 am
Tom.Thomson (3/17/2011)
Craig Farrell (3/16/2011)
GilaMonster (3/16/2011)
I object, I'm a model of good behaviourwell, compared to others on that list anyway...
Isn't that like saying you're a 'nice' barbarian because you only rape...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 17, 2011 at 11:16 am
Viewing 15 posts - 4,576 through 4,590 (of 14,953 total)