Viewing 15 posts - 811 through 825 (of 1,478 total)
Charles Kincaid (9/30/2009)
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 30, 2009 at 9:45 am
I think that it depends. There are some validation that can be done in both places (Application and DB), but other should be done (at least in my opinion)...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 30, 2009 at 8:22 am
Vliet is correct. If you are using log backups in a restore operation, you can use a full backup that was taken with all the log backups that were...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 30, 2009 at 6:47 am
Why do you think that fragmentation causes the dead lock? If you want I can give you a script that causes deadlock on 2 tables that each one of...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 28, 2009 at 4:47 am
You can find this information in the second table in the section that is called “Detecting Fragmentation”. Also notice that this was taken from that same article:
“These values provide...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 28, 2009 at 4:32 am
According to BOL (ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_1devconc/html/a28c684a-c4e9-4b24-a7ae-e248808b31e9.htm)if avg_fragmentation_in_percent value is less then 5%, it is recommended that you won’t reorganize nor rebuild the table. If the avg_fragmentation_in_percent value is between 5% and...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 28, 2009 at 1:02 am
You can’t use a parameter in the command line and add it to the path of the file that should be created.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 25, 2009 at 8:42 am
I don’t think that you should disable the SQL Browser. As far as I know the browser helps when you have named instance on your machine, so if you...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 24, 2009 at 11:26 pm
This is taken from a Microsoft article about SQL Server 2000 http://support.microsoft.com/kb/195565. I couldn’t find an official article about SQL Server 2005.
Sch-M-UPD-STATS: Schema Modification Lock
-----------------------------------------
...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 24, 2009 at 9:39 am
You can modify my code to show more then one year. Here is an example:
declare @StopDate datetime
set @StopDate = '20110101'
;with Months as (
select DATEADD(mm,datediff(mm,'19000101',getdate()),'19000101') as MyDate
union all
select DATEADD(mm,1,MyDate) from...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 24, 2009 at 9:13 am
I’m not sure that the schema locks cause blocking. As far as I know schema locks won’t let you modify the table’s structure but it doesn’t block DML statements...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 24, 2009 at 9:04 am
You can create a view that has all the logic and in the bcp use “SELECT * FROM MyVIEW”.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 24, 2009 at 8:37 am
Web server has nothing to do with the maintenance jobs. Since rebooting the web server “releases” the maintenance jobs, I suspect that you have a blocking chain that...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 24, 2009 at 8:31 am
Like others I didn’t know what to answer. I know that FROM clause can be used in an update statement, but I also noticed that the way that the...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 24, 2009 at 8:21 am
Here is another way of doing so:
;with Months as (
select DATEADD(mm,datediff(mm,'19000101',getdate()),'19000101') as MyDate
union all
select DATEADD(mm,1,MyDate) from Months where Month(MyDate) < 12)
select * from Months
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 24, 2009 at 8:10 am
Viewing 15 posts - 811 through 825 (of 1,478 total)