Viewing 15 posts - 436 through 450 (of 1,478 total)
Just to be sure - did you right click on tempdb in the databases list and then select the refresh from the menu? If you didn't I would give...
--------------------------------------------------------------
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 31, 2011 at 1:49 am
You can restore the backup as a different database instead of overwrite the real database. Then you can use the old version with update/insert statement. I would also...
--------------------------------------------------------------
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 27, 2011 at 8:49 am
Just look at the query plan. The number of times that you see the seek operator in the query plan, is the number of times that the seek operation...
--------------------------------------------------------------
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 27, 2011 at 8:42 am
By default linked servers also use port 1433.
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 27, 2011 at 8:21 am
If both users will run the select statement at the exact same time, then you’ll have a deadlock. When you work with serializable isolation level, the shared locks 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 27, 2011 at 5:26 am
Are you running DBCC CHECKDB with the one of the repair options? If you do, then the database has to be in single user mode. In this case...
--------------------------------------------------------------
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 26, 2011 at 7:19 am
Just ran a slightly modified version of your code with sp_msforeachdb and it works. Here is the code that I've used. If you still have problems with sp_msforeachdb...
--------------------------------------------------------------
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 26, 2011 at 2:42 am
Don't forget to run DBCC CHECKDB to check if you have other problems in the database. I would do it for all databases that are using the same disk/storage.
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 25, 2011 at 1:36 pm
I know that this is a long shot, but I’ve had a case once that an index was corrupted, so when it was used in a query plan, we did...
--------------------------------------------------------------
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 25, 2011 at 5:41 am
prashant-507002 (10/24/2011)
How to do order by on alias column?Select customerID,FirstName +'_'+ lastname as customerName from tblemployee.
Here i want to do order by customername descending
One more way is to specify 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 24, 2011 at 5:14 am
ramyours2003 (10/24/2011)
--------------------------------------------------------------
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 24, 2011 at 3:40 am
Eskandari (9/12/2011)
thanks for your post 'Adi Cohn-120898' but see this:DECLARE @Col nvarchar(50)
SET @Col='?'
SELECT @Col
DECLARE @Col2 nvarchar(50)
SET @Col2=N'?'
SELECT @Col2
First Select result is '?' and second result is '?'
This is beause...
--------------------------------------------------------------
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 12, 2011 at 4:54 am
You don't need to. If the parameter is defined as unicode, then there is no need to add the N before it.
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 12, 2011 at 3:28 am
The maximum number of connections is 32,767 (you can check it out at http://msdn.microsoft.com/en-us/library/ms143432(v=SQL.90).aspx). Of course this is a theoretical issue. I’ve never had a server 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 12, 2011 at 2:58 am
I know that this is a long shot but if the database is case sensitive, then objects’ names (including your procedure’s name) are also case sensitive.
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 6, 2011 at 8:30 am
Viewing 15 posts - 436 through 450 (of 1,478 total)