Viewing 15 posts - 3,406 through 3,420 (of 7,429 total)
UDFs are quite great and have several advanatage factors. However, keep in mind a UDF does not store an execution plan so it loses that advantage as opposed to an...
February 7, 2003 at 3:53 am
Actually type is a calculated column which the def is
(convert(char(2),case when (([xtype] = 'UQ' or [xtype] = 'PK')) then 'K' else [xtype] end))
Seems to be for compatibility.
And as for system...
February 7, 2003 at 3:37 am
No, just set a long password with odd characters such as $ or other (especially the ALT+number stuff). Brute force and dictionary will be less likely to get thru. I...
February 6, 2003 at 8:10 pm
quote:
WITH ENCRYPTION works against everyone, including sysadmin level accounts. However, it's not very strong.There's a script (I think there's a version in...
February 6, 2003 at 8:07 pm
Ok here we go, the steps that occurr to create a table with CREATE TABLE statment.
My example is based on this table DDL
create table tbl_x (
idx int identity(1,1) primary key...
February 6, 2003 at 7:50 pm
Can you tell me about the table and the index? It is hard to help when I don't know anything.
Also, what was the query that did a Scan?
February 6, 2003 at 6:35 pm
Sorry, again no. You cannot CAST TEXT, NTEXT or IMAGE to another datatype.
February 6, 2003 at 11:08 am
Run DBCC UPDATEUSAGE (databasename) should correct it. See BOL for more details.
February 6, 2003 at 11:04 am
Sorry no. However, if you have a unique id or pk value you can link the two tables together you can use set without variables.
UPDATE tbl
SET cols = cols
FROM
querytojoinhistoryandinserted
February 6, 2003 at 9:36 am
No as is currently. The reason is both Person and TaskID has a PersonID field in it. What you need to do is instead of using * list all the...
February 6, 2003 at 5:34 am
quote:
What a load of cols...actually very useful, but tell me, have you ever seen a query plan with index intersection happening? ...
February 6, 2003 at 5:24 am
Forutnately I have not had any issues finding the information either online or within the stupid mistake I made, so I have never had to call. I also, know several...
February 6, 2003 at 5:13 am
Another consideration when using composite index is degree of uniqueness. You should anytime you use a composite index make sure the most to least unique item is the order of...
February 6, 2003 at 4:50 am
I would suggest to confirm what is happening on the box, install Netmon and monitor all incoming and outgoing packets then run the query from that box. Once the data...
February 6, 2003 at 3:39 am
I agree, after some recent updating I would say that due to the fact the logical partitions would in fact be on the same array and channel you will actually...
February 6, 2003 at 3:30 am
Viewing 15 posts - 3,406 through 3,420 (of 7,429 total)