Viewing 15 posts - 436 through 450 (of 1,479 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...
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...
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...
October 27, 2011 at 8:42 am
By default linked servers also use port 1433.
Adi
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...
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...
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...
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
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...
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...
October 24, 2011 at 5:14 am
There is no way to do that automatically. If you'll think about it, you'll realize that it can't be done automatically. The columns have to be named, typed,...
October 24, 2011 at 4:14 am
ramyours2003 (10/24/2011)
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...
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
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...
September 12, 2011 at 2:58 am
Viewing 15 posts - 436 through 450 (of 1,479 total)