Viewing 15 posts - 946 through 960 (of 1,478 total)
Take a look at BOL (Books on line – the help file that comes with SQL Server) at Bulk insert statement. It seems that this is just what 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/
June 8, 2009 at 10:14 pm
This is due to a limitation of openquery. When you use openquery function, you can not use variables in it. This means that you can use dynamic SQL...
--------------------------------------------------------------
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/
June 8, 2009 at 3:04 am
steveb (6/8/2009)
Sumanta Roy (6/8/2009)
The transaction log backup of the user databse has taken the almost disk space(size 122GB). The datbase recovery model is set to full. What is the best...
--------------------------------------------------------------
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/
June 8, 2009 at 2:53 am
Just to add on Erwin's response. In order to avoid this problem in the future you should consider doing one of those options:
1) Modify the database's recovery model to...
--------------------------------------------------------------
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/
June 8, 2009 at 2:50 am
vik_steve (6/8/2009)
The error in log file was:
Autogrow of file ** in database ** cancelled or timed out after...
--------------------------------------------------------------
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/
June 8, 2009 at 2:43 am
You should try and find out the cause of the blocking and not recreate the TempDB or do something else with no connection to the blocking problem that you have....
--------------------------------------------------------------
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/
June 8, 2009 at 2:23 am
Maybe there is a better way of doing it, but the way that I did it used 2 Common table expression (CTE). First here is a small script to...
--------------------------------------------------------------
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/
June 4, 2009 at 9:03 am
yuzzelpiccici (6/4/2009)
But, if i want to create table like this :
CREATE TABLE [WeatherInfo] (
[WeatherID] [int] NOT NULL ,
[DateNow] [datetime] NOT NULL ,
[TimeNow] [datetime] NOT NULL ,
[Until]...
--------------------------------------------------------------
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/
June 4, 2009 at 6:26 am
I still have few questions. If there are few records with the same value in UserUID and Code columns, but 2 of them have today as StartDate 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/
June 4, 2009 at 6:03 am
I don't know of a way of doing it with the GUI, but if you'll read the article that you referred to in your post, you will find all 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/
June 4, 2009 at 3:26 am
declare @time datetime
select @time = getdate()
select @time, convert(char(8),@time,108) as OnlyTime1,
dateadd(dd, datediff(dd,@time,'19000101'),@time) as OnlyTime2
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/
June 4, 2009 at 3:21 am
It depends. If the error happened on a none clustered index, then you can just drop the index and recreate it. If the error is on the clustered...
--------------------------------------------------------------
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/
June 4, 2009 at 1:59 am
Maybe you network admin is blocking the communication between the servers with firewall.
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/
June 4, 2009 at 1:45 am
Tables don't have any order for the records, so you need to specify what you mean when you want to compare the value of column in a record with a...
--------------------------------------------------------------
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/
June 4, 2009 at 1:40 am
vikas bindra (6/2/2009)
I agree with you that I can not drop/change any index before i find out the queries,
But in general, if all 3...
--------------------------------------------------------------
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/
June 2, 2009 at 7:37 am
Viewing 15 posts - 946 through 960 (of 1,478 total)