Viewing 15 posts - 16 through 30 (of 50 total)
Thanks for the reply.
The table definition is big and thus I did not post it here.
The column1 is varchar(100) NULL.
I meant that the second query results in records where column1...
December 6, 2010 at 3:18 pm
Thanks Keith. I shall have a look at the article. I am new to DBA side, so it helps a lot.
November 30, 2010 at 11:20 am
Thank you very much Chris.
November 29, 2010 at 4:12 pm
May I also know, if there is any other way to get the space back, without restarting the service ?
November 29, 2010 at 3:43 pm
Thank you very much Keith.
Thanks Chris.
November 29, 2010 at 3:35 pm
I agree with Steve. Performance is definitely good with CTE's.
Check/Create indexes, that should help.
EDIT:
Also don't use Table variable if you have to process so many rows. That might be the...
September 30, 2010 at 12:40 pm
Getdate() can't be passed as parameter
You may pass it as below
DECLARE @Date datetime
SET @Date = getdate()
exec YourSp @Date
September 30, 2010 at 12:37 pm
Interesting answers by Lynn , Drew and Steve.
Its nice to know of that solution. May I ask for some links/resources to learn XML ?
September 30, 2010 at 10:25 am
Shawn, This might sound silly. how do you paste the code like that, as in I see a separate box there 🙂 ?
September 29, 2010 at 4:41 pm
This should be faster. Do Test if the joins are fine.
SELECT TOP 100 *
FROM dbsrvr2.queues.dbo.OUTqueue2 a (NOLOCK)
WHERE result = 206
AND a.routing like '%1'
INNER JOIN defineroutings d
ON d.routing...
September 29, 2010 at 4:31 pm
DECLARE @test-2 TABLE
(ID INT,
NAM VARCHAR(50))
DECLARE @RESULT TABLE
(ID INT,
RESULT VARCHAR(50))
INSERT INTO @test-2
SELECT 1,'RAM'
UNION ALL
SELECT 1,'PRASAD'
UNION ALL
SELECT 2,'SQL'
UNION ALL
SELECT 2,'SERVER'
UNION ALL
SELECT 2,'CENTRAL'
UNION ALL
SELECT 3,'FAMOUS'
UNION ALL
SELECT 3,'BOOK'
DECLARE @Id...
September 28, 2010 at 5:44 pm
Thanks Gail.
May I ask another question, based on your answer.
When we use 'SELECT *' in our query, then this is helpful. Say that I specify columnNames in my query...
September 28, 2010 at 12:23 pm
Thanks for the reply.
I guess, I did not follow your answer.
I just created view on one server from a table on other server and it gets updated.
September 28, 2010 at 12:02 pm
Viewing 15 posts - 16 through 30 (of 50 total)