Viewing 15 posts - 31 through 45 (of 87 total)
Hi,
If you are using SQL Server 2005 or higher you can enable Row Versioning (Snapshot Isolation Level). It is not the 100% solution but it will be help you some...
December 24, 2010 at 5:31 am
Hi,
My objective is reduce the elapsed time one of my large queries. Thats why I want to test out with Parallel Query Plan. I know it is not fit in...
December 23, 2010 at 7:26 am
sqlchanakya (12/21/2010)
ofcourse, if sql server thinks which ever is best, it will choose.
I do not want to SQL Server to think. I want to force/instruct SQL Server to use...
December 22, 2010 at 12:29 am
what does mean by "You owe me 5.95$" Please make clear.
December 21, 2010 at 8:14 am
make sure you have "SA" or any administrator login before removing local\administrator login from SQL server Instance.
December 19, 2010 at 11:30 pm
saidapur_satish (11/26/2010)
Hi,I am created a user ABC, i want to this user expire after 21 day's......
Hey,
Please provide more details like below
1. ABC use mean -...
November 29, 2010 at 1:24 am
Hi,
Ok! you have taken backup from another SQL Agent but the question coming in mind that what is the purpose of it. What you achieve doing this? or why you...
November 29, 2010 at 1:13 am
Hi,
As per your error I think you are trying to configure mirror on Workgroup environment. Please check BOL for configuring Mirroring in Workgroup.
November 29, 2010 at 12:59 am
Hello all,
I got the answer. I collect "Batch Requests/sec" counter with two intervals 1st with every second and 2nd with 15 seconds of interval. And then I check Counter values...
November 24, 2010 at 11:13 pm
sumit.agrawal (11/24/2010)
It directly impacts the size of log file. For longer time the counters data is collected, interval should be more. No impact on analyzing the counters.
My query related to...
November 24, 2010 at 10:45 pm
Hey!
gr8 Books
1.MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 - Implementation and Maintenance
3. Microsoft SQL Server 2008 Internals
4. Inside Microsoft SQL Server 2008: T-SQL Querying
5. Inside Microsoft...
November 22, 2010 at 6:24 am
Hi,
I have worked on Crystal Reports, MS Access Reports, and SSRS 2008 & R2
SSRS is fantastic, robust, and easy. I love it.
1.Easy to design a report
2.Supports multiple data source
3.Report Manager...
November 22, 2010 at 6:12 am
Respected All,
Everybody is taking my question in a native way. But I am putting this question very gentle that how to interact with non-DBA manger? It is my gentile question...
November 18, 2010 at 6:52 am
Viewing 15 posts - 31 through 45 (of 87 total)