Viewing 15 posts - 21,436 through 21,450 (of 49,552 total)
What do you mean by expiry date?
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
January 3, 2012 at 5:13 am
It depends. Seriously there's no one answer, that's why Jonathan wrote that article. Read over it again, weigh up the pros and cons based on what you know of your...
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
January 3, 2012 at 5:13 am
MasterDB (1/3/2012)
Temporarily data is in very less size and as of now am copying the data to QA Server according client request with simple insert into Statement.
???
That means you'll miss...
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
January 3, 2012 at 3:58 am
MasterDB (1/3/2012)
i hope i can achieve this with merge statement.Kindly share the merge statements.
I can, but I think you missed the portion of my post where I said that was...
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
January 3, 2012 at 3:49 am
1) Optimise your queries (see the links Ninja posted back in November)
2) Reduce server max memory to a sensible value
p.s. And get that book I recommended back in November 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
January 3, 2012 at 3:46 am
Lavanyasri (1/3/2012)
The problem is the SQl server is not releasing the memory .
That's not a problem, that's how SQL Server works, by design and it's documented to work that way.
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
January 3, 2012 at 3:03 am
george sibbald (1/2/2012)
The single user mode solution was posted 3 days ago, and in your parallel thread on the same subject, 4 days ago, did you not believe us?
Feeling ignored...
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
January 2, 2012 at 10:47 am
Have a read through that thread. I can't remember how it is calculated/displayed on 2008 R2.
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
January 2, 2012 at 10:14 am
Your server has either two single core processors or a single dual core and you're using Windows Server 2003 or below?
Depending on the version of windows, the % processor...
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
January 2, 2012 at 9:47 am
Performance monitor. Process(sqlservr.exe) %processor 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
January 2, 2012 at 9:29 am
Start SQL in single user mode. When SQL is running in single user mode all members of the local administrator group are considered members of sysadmin. Hence if you're logged...
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
January 2, 2012 at 8:30 am
MyDoggieJessie (1/2/2012)
I've got a log reuse type of LOG_BACKUP, but there's no transaction log backup running.
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
January 2, 2012 at 8:27 am
The alter table, probably not. That affects the heap, not the index and it's the index that's got the strange size. The deallocation from indexes isn't immediate, but it's reasonably...
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
January 2, 2012 at 8:13 am
MasterDB (1/2/2012)
i'll run this query from source server.
This query will works easy for one OBJECT, But the thing is i've lot...
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
January 2, 2012 at 6:22 am
MasterDB (1/2/2012)
Is there any way to retain yesterdays data in QA Server,in addition i don't want to loose yesterdays data.
Script out the changes, restore the backup, run the scripts 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
January 2, 2012 at 4:46 am
Viewing 15 posts - 21,436 through 21,450 (of 49,552 total)