Viewing 15 posts - 586 through 600 (of 1,478 total)
I don’t think that you can modify the format to LiteSpeed’s format. In any case you can use other tools such as 7zip, Gzip or any other tool 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 13, 2010 at 1:10 am
I have to admit that I was surprised that we can name a column with the data types’ names with no problems at all. Although this can be done,...
--------------------------------------------------------------
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 13, 2010 at 1:05 am
You can’t use empty strings. Instead of the empty strings you should specify where the backup file is located and which fie you want to move.
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/
May 24, 2010 at 2:24 am
Just use dateadd function. Use the parameters hh to specify that you want to use hours and -1 as the amount of hours that you want to add. ...
--------------------------------------------------------------
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/
May 18, 2010 at 3:55 am
Personally I don’t like mixing test and production environment. I would prefer to have 2 different and separated environments for test and production. I think that using...
--------------------------------------------------------------
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/
May 18, 2010 at 2:25 am
Both table variables and temporary tables are created in TempDB. There are few differents between them. When you use table variable the server doesn’t hold statistics on it...
--------------------------------------------------------------
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/
May 18, 2010 at 1:23 am
It could be that you are using a control that does its own sorting or just doesn’t use the order of the rows that it got, but the queries should...
--------------------------------------------------------------
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/
May 17, 2010 at 3:28 am
I wouldn’t change collation just to modify the NULL location in a recordset. Instead I would use a case statement or isnull function. Bellow are 2 examples:
SELECT WhatEver
FROM...
--------------------------------------------------------------
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/
May 17, 2010 at 12:48 am
This is not a bug. Rowlock and pagelock are mutually exclusive, and both state to use either row locks or page locks as long as escalation to page locks...
--------------------------------------------------------------
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/
May 12, 2010 at 10:21 am
If you are looking for the length of time that something took, then you can use the datediff function to calculate the period of time. According to it 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/
May 12, 2010 at 3:25 am
I think that the recordset should still show the continent and country for each city. The presentation s in the way that you want should be done in 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/
May 12, 2010 at 3:12 am
You need to be more specific about the requirements. It is unclear if you want it according to the hours or according to clock (i.e. 2:30 – 2:45 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/
May 12, 2010 at 2:54 am
Very easy to read about it on the net - http://lmgtfy.com/?q=sql+server+2008+new+data+types
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/
May 11, 2010 at 3:08 am
While I agree that it is a good question, I think that there is a mistake in the answers. Since the question states that it is for SQL Server...
--------------------------------------------------------------
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/
May 11, 2010 at 1:46 am
I found how I should do it. I'm adding the answer just in case that it might help someone in the future.
select *
from dbo.UnPivotSourceTable
pivot
(
MIN(ColumnValue) --I have only one value...
--------------------------------------------------------------
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/
May 10, 2010 at 10:48 am
Viewing 15 posts - 586 through 600 (of 1,478 total)