Viewing 15 posts - 646 through 660 (of 1,478 total)
Yes you can. Here is an example:
declare @vb varbinary(12)
set @vb = 0x5375726520796F752063616E
select convert(varchar(12),@vb)
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/
March 2, 2010 at 4:38 am
You can try using the default trace to check if someone issued a backup log statement.
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/
March 1, 2010 at 7:58 am
Do you mean that it returned no records at all? Didn’t stop running? Returned 0 as number of transactions count? Or anything else? Also did you change...
--------------------------------------------------------------
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/
March 1, 2010 at 2:56 am
Are you sure that those are the only statements that were running. Is there a chance that those are the LAST statements that the sessions ran? My guess...
--------------------------------------------------------------
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/
March 1, 2010 at 2:28 am
On my laptop it took 273 MS.
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/
February 26, 2010 at 1:26 pm
I just tried to reproduce your problem, but couldn't. I used your code and then I ran the select statement but got the results very fast. I tried...
--------------------------------------------------------------
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/
February 26, 2010 at 8:59 am
I don’t have a link, but I can try and explain. First of all you are correct when you say that there is a difference between setting deny permission...
--------------------------------------------------------------
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/
February 25, 2010 at 9:25 am
Here is one way:
with MyCTE as (
select lfisno, sum(quantity) as QuantityPerlfisno
from TEST
group by lfisno)
select T.lfisno, Stockcode, quantity, convert(real,quantity)/M.QuantityPerlfisno as rate
from TEST T inner join MyCTE M on T.lfisno =...
--------------------------------------------------------------
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/
February 25, 2010 at 2:23 am
In case that there is a conflict between permissions, the DENY permission will be the one that will be imposed by the server. In your case there is a...
--------------------------------------------------------------
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/
February 25, 2010 at 1:51 am
Can you show the code that doesn't work and add the error that you are getting?
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/
February 24, 2010 at 4:34 am
No default size. When a table is created it has no pages that are allocated to it. When you start inserting data, it will have pages allocate 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/
February 23, 2010 at 5:19 am
I have to admit that it is a long time since I’ve changed the default port, bus as far as I remember, you’ll have to select a fixed port number,...
--------------------------------------------------------------
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/
February 23, 2010 at 5:14 am
This is a very problematic script to write. I think that at best you can write a SQL statement that will bring you closer. For example:
Select object_name(object_id)
From sys.sql_modules
Where...
--------------------------------------------------------------
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/
February 18, 2010 at 8:11 am
The expiration date is not checked when you base the encryption and decryption on a certificate, so your application will continue working after the certificate’s expiration date.
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/
February 11, 2010 at 9:10 am
I don’t think that you can do it in a different day, but the question is what are you trying to do that you need to get random records 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/
February 11, 2010 at 4:14 am
Viewing 15 posts - 646 through 660 (of 1,478 total)