Viewing 15 posts - 3,421 through 3,435 (of 5,394 total)
If performance or availability is not a concern to her, restart the service...:-P
February 24, 2011 at 7:05 am
I don't see any way other than creating a proxy account. Why is it a problem for you?
February 24, 2011 at 12:58 am
I'm afraid it's overcomplicating a simple problem, anyway you could also try this:
;WITH FlagCounts AS (
SELECT IND1, IND2, IND3, IND4, IND5, IND6, IND7, IND8, COUNT(*) AS CNT,
ROW_NUMBER() OVER(ORDER BY (SELECT...
February 23, 2011 at 10:31 am
WITH INDS AS (
SELECT CAST(IND1 AS int) AS IND1,
CAST(IND2 AS int) AS IND2,
CAST(IND3 AS int) AS IND3,
CAST(IND4 AS int) AS IND4,
CAST(IND5 AS int) AS IND5,
CAST(IND6 AS int) AS IND6,
CAST(IND7 AS...
February 23, 2011 at 10:20 am
Well, amazing! 😀
5 posters = 5 different versions of the same trigger!
You should be able to merge everything into a single trigger...;-)
February 23, 2011 at 9:38 am
I see a couple of issues:
1) You're assuming only one row gets inserted/updated at a time.
2) You're assigning to variables read from the source table (Table1) and not from the...
February 23, 2011 at 9:31 am
a_ud (2/23/2011)
February 23, 2011 at 6:22 am
SKYBVI (2/22/2011)
Gianluca Sartori (2/22/2011)
The space allocated by those objects cannot be reclaimed, even if not used.
To reclaim that...
February 22, 2011 at 7:31 am
Marco V (2/22/2011)
DBCC FREEPROCCACHEGO
Please note that DBCC FREEPROCCACHE flushes the procedure cache for the whole server. Depending on your database load, your server could suffer for some minutes due to...
February 22, 2011 at 7:29 am
Tempdb contains internal objects such as spools and hashes used by the queries.
The space allocated by those objects cannot be reclaimed, even if not used.
To reclaim that space, in SQL...
February 22, 2011 at 7:15 am
abhas (2/21/2011)
hi Sartori,table structure is same as presented in below link.
and i want to display servernames as mentioned condition above post.
thank u
Abhas
I guess you have to extract top 50 rows...
February 22, 2011 at 1:57 am
Your query can't execute, it is missing some GROUP BY clauses.
Can you post some sample data from the tables involved?
February 21, 2011 at 7:53 am
Grant Fritchey (2/21/2011)
And this post makes 10,000 points. On to getting 10,000 posts.Figured I'd break the threshold on The Thread.
Congratulations, Grant!
February 21, 2011 at 7:51 am
top 50 records from average of top 90% records
Top by what? Can you post table creation script, some sample data and the expected results?
February 21, 2011 at 6:25 am
I suppose you mean a replacement for ROW_NUMBER function in SQL 2000, right?
February 21, 2011 at 6:23 am
Viewing 15 posts - 3,421 through 3,435 (of 5,394 total)