Viewing 15 posts - 781 through 795 (of 1,478 total)
For some reason you don’t want to explain what you need. From what I understood, you already have an SQL Server installed on your machine and you 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/
November 3, 2009 at 3:42 am
lamin.mha (11/3/2009)
Adi Cohn-120898 (11/3/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/
November 3, 2009 at 3:14 am
You’ll have to explain your question. Do you want to install a second instance on a server? Do you want to rename an SQL Server instance? Or...
--------------------------------------------------------------
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/
November 3, 2009 at 3:12 am
It looks that you have few places with an apostrophe in the string (for example one of your parameters in the first error that you get is ...
--------------------------------------------------------------
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/
November 3, 2009 at 3:07 am
The option to enable or disable xp_cmdshell with sp_configure was intreduced only SQL Server 2005. With SQL Server 2000 this extended stored procedure is always enabled.
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/
November 2, 2009 at 2:28 am
Do you get any errors? Are you sure that you are connecting to the correct server? Did you try to see with profiler or another tool 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/
November 2, 2009 at 2:22 am
At first I thought that you are talking about the tables’ and index’s statistics that are part of the database and therefore are being restored with the database. Now...
--------------------------------------------------------------
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 29, 2009 at 5:41 am
You shouldn’t rely in your code on the configuration or setting of the server/session. You should make sure that your code will run regardless of the language and date...
--------------------------------------------------------------
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 29, 2009 at 5:05 am
What type of restore are you using? Are you restoring parts of the database only? Also how did you determined that the statistics are not being restored?
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/
October 29, 2009 at 4:20 am
I don’t really know what military format is. You asked for a specific format in the first message and I wrote a code that shows the date using 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/
October 29, 2009 at 3:53 am
Here is another way of doing so:
select convert(char(5),getdate(),9)
select convert(varchar(10),getdate(),101) + ' ' + convert(char(5),getdate(),8) +
CASE WHEN DATEPART(hh,getdate())>= 12 then ' PM' ELSE ' AM' END
Notice that althgou...
--------------------------------------------------------------
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 29, 2009 at 3:28 am
Nero-1119276 (10/29/2009)
If i write this codebackup database to disk='Path'
Now what should i use to include date in backup name likewise
testbackup01-01-2009.bck
You’ll have to use the date and time as a part...
--------------------------------------------------------------
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 29, 2009 at 12:31 am
The easiest way is to use the maintenance wizard. It will create a different file for each backup and will delete old files according to the way that 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/
October 29, 2009 at 12:05 am
I think that you can do it by running bulk insert command or using insert select statement with openrowset function and the bulk driver (you can read about both...
--------------------------------------------------------------
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 28, 2009 at 4:44 am
You can use the DMV sys.dm_os_performance_counters. This DMV gives you the performance monitor’s counters in a table format. The query bellow shows how to get the memory 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/
October 28, 2009 at 1:50 am
Viewing 15 posts - 781 through 795 (of 1,478 total)