Ninja's_RGR'us

Forum Replies Created

Viewing 15 posts - 1,576 through 1,590 (of 18,926 total)

RE: Are the posted questions getting worse?

Ninja's_RGR'us (10/31/2011)
We all knew this was coming....
Edit : And here's the kicker... Attachment # 10111. Only 1 bit off of being #1 all across the board :w00t:.
And I...

November 1, 2011 at 6:39 am

#1401572
RE: Are the posted questions getting worse?

WayneS (11/1/2011)
Ninja's_RGR'us (11/1/2011)
Talking about a race, anybody got spare time for a "quick" fix?
http://www.sqlservercentral.com/Forums/Topic1198539-146-1.aspx
Apologies to bring this back on topic :hehe:!
Dang, folks always trying to get this thread back on...

November 1, 2011 at 6:37 am

#1401569
RE: Reporting services export to Excel

Have you checked what's happening server side?
Query stuck?
Rendering stuck?
Anything in any of the logs?
Exec log, windows & sql logs?
Can you export the same report with the same parameters on another...

November 1, 2011 at 6:30 am

#1401565
RE: Stored procedure performance

WayneS (11/1/2011)
dm_tapas (11/1/2011)
The below stored procedure is taking around 1 hours to execute. but it should not take this much time.
Can some body tune this and tell...

November 1, 2011 at 6:26 am

#1401563
RE: Stored procedure performance

dm_tapas (11/1/2011)
WHERE PE.PEDONE >= @StarDate AND PE.PEDONE < DATEADD(D, 1, @StarDate)
What is D here.
F1 broken?
d is for day.

November 1, 2011 at 6:23 am

#1401562
RE: PF usage Problem

@Gail, take over from here. Getting outside my confort zone and no time to research.

November 1, 2011 at 6:22 am

#1401561
RE: CONVERT(varchar(@MAXLENGTH),x) FROM y

Actually Phil's answer is brilliant.
Great way to think outside the box! :w00t:

November 1, 2011 at 6:21 am

#1401560
RE: PF usage Problem

http://msdn.microsoft.com/en-us/library/ms178067.aspx

November 1, 2011 at 5:50 am

#1401538
RE: Are the posted questions getting worse?

Kiara (11/1/2011)
Well, since figuring it out is on my list of fairly critical things to do, I'll let y'all know what I come up with. SSL certificate is getting installed...

November 1, 2011 at 5:48 am

#1401537
RE: Sql server get the creation date column

No in the OP, I had misread that phrase => Insert a column X between A and B column.
😀

November 1, 2011 at 5:42 am

#1401534
RE: PF usage Problem

MasterDB (11/1/2011)
Ninja:i set max server memory for SQL is 40722MB
Should i decrease it or increase?
You can't assign memory that isn't on the machine. You need to decrease it to...

November 1, 2011 at 5:39 am

#1401531
RE: CONVERT(varchar(@MAXLENGTH),x) FROM y

Your final select will have to be dynamic sql.
You cannot do VARCHAR(@variable).

November 1, 2011 at 5:38 am

#1401529
RE: PF usage Problem

Ninja's_RGR'us (11/1/2011)
PF usage is through the roof because Windows is starving.
You need to set the max memory of sql server low enough so that the OS will have 4-5 GB...

November 1, 2011 at 5:36 am

#1401527
RE: Sql server get the creation date column

John Mitchell-245523 (11/1/2011)
I would advise using the GUI to insert a new column between two existing columns.
Did I miss something in the conversation?
Edit YUP.
There's no point in putting...

November 1, 2011 at 5:34 am

#1401524
RE: Sql server get the creation date column

There's no date column in that table. The best you can do afaik is to order by column_id which is like an identity column for each object in that...

November 1, 2011 at 5:33 am

#1401522

Viewing 15 posts - 1,576 through 1,590 (of 18,926 total)