Viewing 15 posts - 46,381 through 46,395 (of 49,552 total)
This should give you several options
http://www.google.com/search?hl=en&q=Adventureworks+database&meta=
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2008 at 12:58 am
And if you run the hinted query along with the otiginal, how are the relative costs, how are the IOs (SET STATISTICS IO ON), how is the duration (SET STATISTICS...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2008 at 12:35 am
Firstly, you can set the DB back to simple recovery mode. You can shrink the logs insimple, you just can't back them up.
The open tran info shows that the DB...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2008 at 12:25 am
rbarryyoung (5/26/2008)
Posters who say "...this returns an error." or "...this doesn't work."
People; PLEASE do not leave it at this, give us ALL of the relevant information! If...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2008 at 12:21 am
Then rather post in the SQL 2000 forum please. Posting in the 2005 forum, you will get just that, a useless suggestion that wasted both out times.
Now... Is the database...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2008 at 12:09 am
I take it you didn't like the replies to your previous, identical, post
http://www.sqlservercentral.com/Forums/Topic506239-65-1.aspx
My guess is that the index is not covering (which with 300+ columns in SQL 2000 it can't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2008 at 12:06 am
Assuming 2005, query the sys.database view and check the value of the column log_reuse_wait_desc (or something similar). That tells you the reason that the log space cannot be reused.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2008 at 12:00 am
Don't think so, but you can rename it. Not as good, but it does make it less obvious. Call it something like guest_user_testing or something like that and give it...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2008 at 11:58 pm
State 16 means that the login does not have rights on default db. That would explain why recreating the report service database fixed the issue.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2008 at 7:50 am
mobasha (5/25/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2008 at 7:43 am
You can disable the sa account. On SQL 2005, you can also rename it if you like (and create a new login named sa with any permissions you like), however...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2008 at 7:41 am
Did you enter the correct password? Does that login have rights in the server?
What's the State listed for the error? (Error 18456, Severity 14, State ??)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2008 at 7:29 am
Run a checkdb over that database, see if it gives any errors.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2008 at 5:44 am
NT Authority\System is the username for any account that runs as LocalSystem
Generally the sQL services should not be running as local system. They should ahve their own domain accounts.
If you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2008 at 4:56 am
In SQL 2000, I don't think you can. You can encrypt the procedures, but it's a fairly trivial procedure to decrypt them
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2008 at 4:52 am
Viewing 15 posts - 46,381 through 46,395 (of 49,552 total)