Viewing 15 posts - 811 through 825 (of 1,065 total)
1) Start the instance of SQL Server in master-only recovery mode by entering one of the following commands at the command prompt. The parameters specified in these commands are case...
July 15, 2009 at 3:12 am
Instead of running batch of query using C# code,
create a stored procedure with all these queries and call the stored procedure from the C# code.
July 14, 2009 at 5:56 am
Why do you want to use any other operator instead of ;?
The semicolon character is a statement terminator. It is a part of the ANSI SQL-92 standard.
SQL Server 2008 Books...
July 14, 2009 at 3:59 am
BOL
Rebuilding or reorganizing small indexes often does not reduce fragmentation. The pages of small indexes are stored on mixed extents. Mixed extents are shared by up to eight objects, so...
July 14, 2009 at 12:04 am
The Size in pages column shows that your tables are very small. For such small tables you will not see much difference after rebuilding the index.
What you are trying to...
July 13, 2009 at 11:17 pm
okaticl (7/13/2009)
It would be great if someone can me help me understand exactly why is it recommended to stop SQL Server serivces before installing a service pack.Thanks much
Service pack installer...
July 13, 2009 at 11:04 pm
Using SSRS "subscription" it is possible to email a report.
I have done this in SQL Server 2005. I don't have 2000 to check this feature.
July 13, 2009 at 4:24 am
Abhijeet Dighe (7/10/2009)
Table is having millions of records. So from 3-4 hrs it is executing alter operation.
I want to kill...
July 10, 2009 at 6:50 am
Change the "Copy user trigger" properties to True.
Indexes, constraints, etc. you can replicate in this way. They are not indepent objects. They are dependant on table.
July 8, 2009 at 6:57 am
SAT_SQL (7/6/2009)
as i am new to sql , please let me now weather i can upgrade sql200 to sql2005,
If it is possiable please send some links that ...
July 6, 2009 at 1:13 am
SAT_SQL (7/6/2009)
as i am new to sql , please let me now weather i can upgrade sql200 to sql2005,
If it is possiable please send some links that ...
July 6, 2009 at 1:07 am
Apply the service pack firstly to your dev, test and staging servers. If there is no issue, apply it to the production server.
Applying SP3 needs server reboot. So inform the...
July 2, 2009 at 6:42 am
I have run the DBCC CHECKDB. It has not reported any error.
This is happening for tempdb.
June 11, 2009 at 10:34 pm
Thanks Gail,
You are a genious!
Your solution worked.
Thanks.
June 3, 2009 at 3:22 am
Viewing 15 posts - 811 through 825 (of 1,065 total)