Viewing 15 posts - 31 through 45 (of 88 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...
Ram
MSSQL DBA
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...
Ram
MSSQL DBA
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...
Ram
MSSQL DBA
December 22, 2010 at 12:29 am
what does mean by "You owe me 5.95$" Please make clear.
Ram
MSSQL DBA
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.
Ram
MSSQL DBA
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 -...
Ram
MSSQL DBA
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...
Ram
MSSQL DBA
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.
Ram
MSSQL DBA
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...
Ram
MSSQL DBA
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...
Ram
MSSQL DBA
November 24, 2010 at 10:45 pm
anyone plz help.
Ram
MSSQL DBA
November 24, 2010 at 9:59 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...
Ram
MSSQL DBA
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...
Ram
MSSQL DBA
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...
Ram
MSSQL DBA
November 18, 2010 at 6:52 am
Viewing 15 posts - 31 through 45 (of 88 total)