Viewing 15 posts - 11,431 through 11,445 (of 49,552 total)
What are you trying to count? If all the rows in the table, then you can query sys.partitions or sys.dm_db_partition_stats (sysindexes is deprecated and should not be used). If you're...
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 4, 2013 at 12:42 pm
Restore your last full backup as a new database (restore with norecovery), restore all log backups taken up to the point of the accident WITH STOPAT and specify a time...
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 4, 2013 at 12:41 pm
Yes, I gathered as much. What I said stands.
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 4, 2013 at 12:37 pm
OnlyOneRJ (10/4/2013)
Right Andrew.. but they will not do so.. they have asked a developer to perform this task:-D
Start by updating your resume, because a company that won't hire a person...
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 4, 2013 at 11:24 am
Yup.
Generally it's not a good idea to shrink tempDB anyway. Unless the system is completely quiesced, shrinking TempDB can cause corruption that will require a restart to fix (there's...
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 4, 2013 at 11:21 am
kotharibij (10/4/2013)
Given that, I will need extra 2 GB on it to make it functional - production server.
Is it a good time to point out that my home gaming...
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 4, 2013 at 10:24 am
SQLSERVERAGENT service stopping due to a stop request from a user<c/> process<c/> or the OS...
Maybe check the windows event log?
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 4, 2013 at 8:23 am
IgorMi (10/4/2013)
PLE min values should not go under 300 seconds.
That was a poor recommendation 8 odd years ago when servers had maybe 4GB of memory. These days it's a...
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 4, 2013 at 4:13 am
Depends on the requirements and constraints. There's no one that's best always.
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 4, 2013 at 4:11 am
The edition is tied to the key, however some variations of the installation media have the key embedded and can't be changed. The developer editions I get from MSDN are...
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 3, 2013 at 1:23 pm
Avatars borked?
Edit: Apparently not. Either temporary or local problem.
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 3, 2013 at 8:19 am
jason123 (10/3/2013)
Sorry could you please explain what are differences between configuring the schedule to back up transaction log and truncate t-log?
That's in the article I referenced.
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 3, 2013 at 8:03 am
Please take a read through this: http://www.sqlservercentral.com/articles/Administration/64582/
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 3, 2013 at 7:57 am
Brandie Tarvin (10/3/2013)
Ed, your post doesn't actually have a reply from you in it. Just quoted text. @=)
It does, he cleverly concealed it.
I find I have to walk away sometimes,...
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 3, 2013 at 6:18 am
Max server memory controls the buffer pool. SQL uses a small amount of memory outside of the buffer pool as well. If SQL's using too much memory, drop max 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
October 3, 2013 at 6:08 am
Viewing 15 posts - 11,431 through 11,445 (of 49,552 total)