Viewing 15 posts - 36,346 through 36,360 (of 49,552 total)
Operating system error 5 is Access Denied. It means that the SQL Server service account does not have full permission on the directory or the SQL Server Service account does...
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
October 12, 2009 at 6:18 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic801495-391-1.aspx
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
October 12, 2009 at 6:16 am
Are you talking about the transaction logs?
Try backing the tran logs up more often than once a day. Try switching the DB to bulk-logged recovery for the duration of 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
October 12, 2009 at 6:14 am
Eric1208 (10/11/2009)
I receive a 150GB (maybe more) flat file from customer regularly. And It will take me 2 or 3 days to import into DB.
2-3 days to import 150GB?...
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
October 12, 2009 at 2:16 am
imSQrLy (10/10/2009)
I am trying to help the client and do not have 230 GB available to me and nor do they.
Tell the client that if they can buy a 250GB...
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
October 10, 2009 at 12:52 pm
Jody F Powlette (10/10/2009)
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
October 10, 2009 at 12:49 pm
Please post execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
There's no way you'll get an index seek with this query. There's no filter condition. A scan is about the best you'll get and...
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
October 10, 2009 at 9:11 am
JDixon-385826 (10/10/2009)
Also when you do a SELECT COUNT(*) you are scanning the whole table so changing the indexes around will not help
Count(*) will scan the smallest (most efficient) index 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
October 10, 2009 at 6:23 am
Lowell (10/10/2009)
DBCC UPDATEUSAGE (0) WITH COUNT_ROWS, NO_INFOMSGS
SELECT OBJECT_NAME(ID) AS TableName, [Rows]
FROM dbo.SysIndexes
...
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
October 10, 2009 at 6:21 am
Why on earth do you have a table with 400+ columns?
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
October 10, 2009 at 6:13 am
WayneS (10/9/2009)
FYI, you're missing the ";" in front of the "WITH i_copied_this_from_the_internet_CTE AS"
He's not. Look at the statement preceding the CTE. It's terminated with a ;
The requirement for a CTE...
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
October 10, 2009 at 6:12 am
Manie Verster (10/9/2009)
I am glad to say that it looks like the banks in South Africa goes out of their way to help people develop.
Some yes, some no. Bear...
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
October 10, 2009 at 2:45 am
oscar_otrebla (10/9/2009)
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
October 9, 2009 at 11:56 am
parthi-783546 (10/9/2009)
Can any one tell which one is better in production
1)Log shipping
2)Replication
3)Mirroring
...
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
October 9, 2009 at 10:31 am
Krasavita (10/9/2009)
By looking at my results by DBCC page how do you see there is a problem????
Someone who knows the page structure really, really well (like Paul does) can look...
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
October 9, 2009 at 10:10 am
Viewing 15 posts - 36,346 through 36,360 (of 49,552 total)