Viewing 15 posts - 1,426 through 1,440 (of 1,479 total)
ggraber (10/15/2008)
I have heard two different views on this:
1. Yes. There is only one...
--------------------------------------------------------------
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/
October 15, 2008 at 11:18 pm
joselefou (10/15/2008)
I would like to know exactly what SQL queries are received by SQL server during an amount of time.
SQL Server Profiler...
--------------------------------------------------------------
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/
October 15, 2008 at 12:45 pm
CrazyMan (10/15/2008)
I am having a table with 5 columns, with 2 big int columns, 1 int and 1...
--------------------------------------------------------------
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/
October 15, 2008 at 9:24 am
Kishore.P (10/13/2008)
If table structure already exist, use BCP or BULKINSERT command.Otherwise use select * into ]
BCP and BULKINSERT are used to move data between SQL Server 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/
October 13, 2008 at 6:12 am
sandhyarao49 (10/13/2008)
Thanks to All.Suppose if i want to copy a table from one server to another server
what is the best approach to do this task.
Thanks,
Sandhya
You can use linked...
--------------------------------------------------------------
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/
October 13, 2008 at 6:05 am
sandhyarao49 (10/12/2008)
HI TO ALL,
I WANT TO COPY SOME ROWS FROM ONE TABLE IN ONE DATABASE TO ANOTHER DATABASE.
IS THERE ANY EASY APPROACH TO PERFORM THIS TASK
THANKS,
SANDHYA;)
Something like this:
INSERT INTO TargetDB.dbo.TargetTBName...
--------------------------------------------------------------
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/
October 12, 2008 at 4:14 am
Dugi (10/12/2008)
GilaMonster (10/12/2008)
The compatibility level just affects the parser and query processor and change the way that T-SQL is interpreted and what command are permitted.
Ok I have experience from 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/
October 12, 2008 at 3:21 am
jjssilva (10/10/2008)
I did check the server and confirmed that the time is is correct with all the other machines, but SQL still has that time difference.
I'm clueless here. I've checked...
--------------------------------------------------------------
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/
October 10, 2008 at 9:40 am
yulichka (10/9/2008)
I open my servers in 2005 and we have bunch of servers still in 2000 enviroment, how do I know which enviroment is I am inn? Thank you
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/
October 9, 2008 at 10:07 am
bang.prashant (10/9/2008)
Now I have to modify the table and add two new column column A, ColumnB in between Column1 & Column2.
So new columns list will...
--------------------------------------------------------------
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/
October 9, 2008 at 10:04 am
jjssilva (10/9/2008)
I'm comparing the time between this SQL Installation and all the servers in the Domain. This SQL Instance is the only one with this time difference. All the others...
--------------------------------------------------------------
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/
October 9, 2008 at 9:47 am
jjssilva (10/9/2008)
I've searched alot for this info but the only thing I can find is how to change the default Language for the users.
What happens is that I have Microsoft...
--------------------------------------------------------------
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/
October 9, 2008 at 9:13 am
joey.burgett (10/9/2008)
I've tried the suggestions and upon further testing, it appears that using ANY quoted value inside the dynamically generated statement fails.
I tried it against...
--------------------------------------------------------------
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/
October 9, 2008 at 8:44 am
Dan Ellison (10/8/2008)
I don't want 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/
October 9, 2008 at 8:36 am
Vincent Central (10/9/2008)
Thank you all for your replies. I have "coached" the offending developers 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/
October 9, 2008 at 6:55 am
Viewing 15 posts - 1,426 through 1,440 (of 1,479 total)