Viewing 15 posts - 15,496 through 15,510 (of 49,552 total)
Find a quiet time when the active portion of the log is at the beginning of the log file. Shrink the log as small as possible. Grow it back 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
November 27, 2012 at 12:09 am
itis4junk (11/26/2012)
Instance: NULLIsClustered: 0
ComputerNamePhysicalNetBIOS: MainProduction1
Edition: Standard Edition (64-bit)
ProductLevel: SP1
ProductVersion: 10.0.2531.0
ProcessID: 1608
Collation: SQL_Latin1_General_CP1_CI_AS
Standard edition cannot create compressed backups. It's an enterprise-only feature in SQL 2008 (It's in Standard Edition in SQL...
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
November 27, 2012 at 12:07 am
sqldba_newbie (11/26/2012)
All this time i was thinking that if at any point sql needs more than 52 gb it would use page file.
No. By setting max server memory to 52...
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
November 27, 2012 at 12:05 am
shohelr2003 (11/26/2012)
Now my query is when does this message appear? Or what does it imply?
That the log file is not been reused because a log backup is required
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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
November 27, 2012 at 12:01 am
If you're adding files just to relieve allocation contention, they can be on the same drive. If you're adding files because you have IO contention on TempDB, then adding more...
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
November 26, 2012 at 11:58 pm
Please post new questions in a new thread. Thank 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
November 26, 2012 at 11:55 pm
SQL_ME_RICH (11/26/2012)
Perry - thank you for confirming this. I knew it was a DBCC command that needed to be issued.
It's not a DBCC command. Just the ALTER...
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
November 26, 2012 at 11:21 am
tafountain (11/26/2012)
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
November 26, 2012 at 11:11 am
It'll work.
Use ShrinkFile, not ShrinkDB and just shrink the files that have lots of free space in them. Don't shrink as small as possible, leave some free space in 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
November 26, 2012 at 11:09 am
boobalanmca07 (11/26/2012)
how to use now() function in sql server
You don't. It's an MS Access and VB function. Doesn't exist in SQL Server.
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
November 26, 2012 at 8:24 am
Weird.
When you have some time, see if you can dig up a memory test tool, make sure your memory's working properly.
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
November 26, 2012 at 8:22 am
Please don't post multiple threads for the same problem.
No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1388609-149-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
November 26, 2012 at 7:39 am
CREATE PROCEDURE <procedure name>
AS
-- statement one
-- statement two
-- statement three
GO
What specific problem are you having?
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
November 26, 2012 at 7:27 am
Have you installed anything new, any patches, drivers, etc?
Maybe a reinstall of SQL?
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
November 26, 2012 at 7:25 am
Send them the book Anthony mentioned and tell them to read chapter 4, and explain to them that high memory usage is normal and that they should stop telling 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
November 26, 2012 at 7:23 am
Viewing 15 posts - 15,496 through 15,510 (of 49,552 total)