Viewing 15 posts - 32,401 through 32,415 (of 49,552 total)
As the error clearly states, backup log is not allowed when the database is in simple recovery (which AdventureWorks is). If you want to plan with log backups, switch 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
June 16, 2010 at 11:44 pm
Maybe start here: http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/
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
June 16, 2010 at 11:40 pm
Gianluca Sartori (6/16/2010)
Oh, don't be too picky, Gail! You know what I mean
Sorry, habit from too many inane questions posted around here.
The optimiser can't identify all equivalent query patterns. Also...
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
June 16, 2010 at 3:41 pm
Not exactly. You should limit it and the more memory that the server had, the more memory should be left for the OS. My very rough rule of thumb is...
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
June 16, 2010 at 3:27 pm
If the server really does have 10GB of memory (which is a seriously odd amount) set max memory to 8GB.
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
June 16, 2010 at 2:43 pm
A 5 MB word document? Save the image as a jpg or png and attach that.
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
June 16, 2010 at 2:42 pm
http://sqlinthewild.co.za/index.php/2008/09/04/comparing-date-truncations/
If you can, use the datediff on only one column or on the variable/parameter so that the predicate is sargable (though if you're comparing two columns it may not make...
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
June 16, 2010 at 1:27 pm
Good luck.
I have no problems with devs having db_owner in the development environment, but they shouldn't have elevated permissions in production.
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
June 16, 2010 at 1:20 pm
What's the SQL instance's max memory set to ?
10GB memory? That's a fairly odd amount.
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
June 16, 2010 at 1:20 pm
mitchismoney (6/16/2010)
Is there any way to prevent members of the db_owner role from running the DBCC ShrinkFile command?
No. Db_owner has full control over the database and can do anything to...
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
June 16, 2010 at 12:55 pm
MothInTheMachine (6/16/2010)
So does the idea sound any better now? 🙂
No, for one simple reason - redundancy. You've got no RAID there, you've got a single point of failure, if that...
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
June 16, 2010 at 10:53 am
To start with, because they are not equivalent queries.
CREATE TABLE #SomeTable (
SomeColumn INT
)
INSERT INTO #SomeTable (SomeColumn)
VALUES (1), (2), (2)
GO
SELECT MAX(SomeColumn)
FROM #SomeTable
SELECT SomeColumn
FROM #SomeTable AS A
WHERE NOT EXISTS (
...
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
June 16, 2010 at 10:49 am
SELECT p.name, per.permission_name, per.state_desc
FROM sys.server_principals p
INNER JOIN sys.server_permissions per ON p.principal_id = per.grantee_principal_id
WHERE per.type = 'COSQ'
HasAccess is equivalent to 'GRANT' or 'GRANT_WITH_GRANT' states. DenyLogin is equivalent to the...
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
June 16, 2010 at 9:20 am
Grant Fritchey (6/16/2010)
I swear, about a third of our IT staff could fall into a bottomless pit and we wouldn't notice for a week.
Back when I worked at the bank...
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
June 16, 2010 at 8:36 am
Try sys.server_principals in combination with sys.sql_logins
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
June 16, 2010 at 8:31 am
Viewing 15 posts - 32,401 through 32,415 (of 49,552 total)