Viewing 15 posts - 6,211 through 6,225 (of 6,676 total)
R. van Laake (8/5/2008)
Thanks for your input.... however being a newbie about where (or where not) to place SP's I'm not quite getting it. I understand that when you...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 5, 2008 at 2:37 pm
I am guessing here - but, I think you are trying to deploy the report incorrectly.
You should be deploying to: http://servername/ReportServer
I suspect you are trying to deploy to: http://servername/Reports
As far...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 5, 2008 at 2:10 pm
A couple of things you should look at:
1) Setting MIN/MAX memory (which you have already done)
a) Make sure MIN is at least 1GB...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 5, 2008 at 1:54 pm
Great - glad I could help.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 5, 2008 at 12:44 pm
The sa account will be mapped to the user dbo when the owner of the database is sa. If you don't want sa to be dbo - then you...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 5, 2008 at 12:22 pm
First, you need to enable Database Mail (not SQL Mail, which requires a MAPI client be installed on the server - e.g. Outlook). Once you have configured Database Mail,...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 4, 2008 at 9:42 pm
BTW, according to BOL this has changed:
Starting with Microsoft SQL Server 2005, SQL Server allows specifying ordering columns from tables in the FROM clause that are not specified in the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 4, 2008 at 2:40 pm
Can you post the query that is causing the problem?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 4, 2008 at 2:18 pm
Most likely the sa account is the owner of the database and is mapped to the 'dbo' user. If you want to prevent the application from using the sa...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 4, 2008 at 2:13 pm
Jack Corbett (8/4/2008)
They do the same thing, just a slightly different syntax. I prefer using Convert. I believe CAST is more widely implemented by other database platforms.
Although you...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 4, 2008 at 1:48 pm
rbarryyoung (8/4/2008)
Jeff Moden (8/4/2008)
I wonder how they do running totals in data warehouses in SQL Server?
Either in pre-processing (the Load step of the ETL) or in post-processing (the Analysis client)....
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 4, 2008 at 1:35 pm
Jeff Moden (8/4/2008)
I wonder how they do running totals in data warehouses in SQL Server?
Several ways, that I have seen. One is to calculate the running totals during the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 4, 2008 at 10:20 am
Jeff Moden (8/3/2008)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 3, 2008 at 9:28 pm
Jeff Moden (8/3/2008)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 3, 2008 at 6:37 pm
Jeff Moden (8/3/2008)[hrSecond idea sounds good to me. Will the report return the columns named in the NVP table horizontally automatically and in the correct order? I ask...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 3, 2008 at 6:20 pm
Viewing 15 posts - 6,211 through 6,225 (of 6,676 total)