Viewing 15 posts - 1 through 15 (of 17 total)
JC-3113 (11/17/2009)
trivial question on changing the column name using an alias in a CASE statment.
Is there a way to do that in this example
Would like to change "denylogin" to...
November 17, 2009 at 1:11 pm
jstuparitz (9/30/2008)
October 13, 2008 at 9:32 am
I got my answer on the MSDN Forums, so I am posting it here.
Brian Hartman - MSFT
The standalone ReportViewer control does not ship with SQL Server, so there is...
July 11, 2008 at 6:08 pm
I got my answer on the MSDN Forums, so I am posting it here.
Brian Hartman - MSFT
The standalone ReportViewer control does not ship with SQL Server, so there is...
July 11, 2008 at 6:08 pm
If it is in FULL recovery mode, are the backups occurring? If you don't back it up regularly, the log gets really big in a system that gets used...
June 19, 2008 at 6:30 am
ping... anyone have any idea how to do this?
May 2, 2008 at 3:00 pm
When you say 'view externally from the network', what do you mean? Are you hitting the reporting services web server with http://(servername)/reports ?
I suspect it has something...
April 9, 2008 at 7:00 am
Here is an error from the event application log just about the same time as the hang:
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:17052
Date:4/2/2008
Time:3:25:41 PM
User:N/A
Computer:HTEDW01
Description:
The description for Event ID ( 17052 ) in...
April 2, 2008 at 1:43 pm
I will try expanding the page file on the local C: drive and removing it from the SAN drive to see if that helps. I just experienced another hang...
April 2, 2008 at 1:36 pm
Timothy Ford (4/2/2008)
Enough with the editorializing though, does the service account for SQL have the right to Lock Pages in Memory? If not,...
April 2, 2008 at 9:32 am
No file copying going on that I am aware of, no. The DW gets loaded once a day, between 3 and 5 am. I do a schedule SQL...
April 2, 2008 at 7:22 am
You can set it to restart on issues and even notify you if it's down.
How would I set SQL Agent to notify me if it goes down/offline?
I am having a...
March 27, 2008 at 6:27 am
If it makes you feel any better, I have to so something similar to this. On the first of each month, the query pulls data going back the previous...
March 21, 2008 at 7:36 am
A great tip, thanks!
However, I find it interesting, now that I am aware of this property, that it doesn't seem to work if you explicitly set the height value. ...
March 20, 2008 at 6:10 am
I don't know if this is a possibility given your hardware constraints, but there is another combination that would also be good to try.
Array 1 - OS/Apps
Array 2 - TempDB...
March 20, 2008 at 5:58 am
Viewing 15 posts - 1 through 15 (of 17 total)