Viewing 15 posts - 1,741 through 1,755 (of 5,685 total)
Jeff Moden (2/25/2012)
It'll be so close that I can ride my unicycle to work without having to powder for chaffing. 😀
This is a YouTube video just WAITING to happen....
February 27, 2012 at 1:11 pm
CELKO (2/23/2012)
February 27, 2012 at 1:03 pm
*vivian* (2/26/2012)
The environment is a cluster. Only this node is having weird problem. Once move the SQL instance to the other node, run the query locally it is very quick.
This...
February 27, 2012 at 12:44 pm
jd 67003 (2/23/2012)
February 23, 2012 at 4:57 pm
To your specific points.
File Watcher: I've never had much luck with this and usually just iterate the job to repeat every 5 minutes or so, with a quit successfully if...
February 23, 2012 at 3:49 pm
I can't find anything wrong with it visually. It seems fine. I can't test your statement in any way because it's been heavily modified (see WHERE...conditions).
Due to that,...
February 23, 2012 at 3:21 pm
You didn't close the statement for q and you've got an extra comma in your delimited list. It looks like the end of that line is just trimmed off.
Ignore...
February 23, 2012 at 3:16 pm
We're getting there. Sorry this is taking a few iterations, I know you're trying.
A few questions. While trying to slap together some very limited sample data into these...
February 23, 2012 at 3:10 pm
What's the error you're getting?
February 23, 2012 at 2:58 pm
I need to see the query to help you directly, but basically what you want is a sub-query that will grab the max timestamp for each of the 36 records...
February 23, 2012 at 12:35 pm
Lowell (2/22/2012)
one tells you who belongs to a group, the other can tell you all the grouls i belong to:
EXEC master..xp_logininfo
@acctname...
February 23, 2012 at 12:31 pm
*vivian* (2/22/2012)
The query I run returns a lot of data (50000), do you think it could because both server activites and client activites happen on this SQL Server so...
February 22, 2012 at 5:14 pm
What's the server set to consume for memory? The reason I ask is the client for SSMS may barely have enough room to run via RDC but your local...
February 22, 2012 at 5:14 pm
SQLBill (2/20/2012)
February 22, 2012 at 5:02 pm
ColdCoffee (2/22/2012)
Both of them wont work if the number of degrees queried is just one.
Agreed, I was answering the initially asked question of what method to use rather then providing...
February 22, 2012 at 3:37 pm
Viewing 15 posts - 1,741 through 1,755 (of 5,685 total)