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',
...
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,...
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...
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.
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...
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.
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...
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...
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...
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...
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. ...
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...
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)
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...
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...
March 17, 2011 at 11:16 am
Viewing 15 posts - 4,576 through 4,590 (of 14,953 total)