Viewing 15 posts - 6,151 through 6,165 (of 8,754 total)
Quick suggestion, query the sys.sql_dependencies view
😎
SELECT
OBJECT_NAME(SD.object_id) AS OBJ_NAME
,OBJECT_NAME(SD.referenced_major_id) AS DEPENDENT_NAME
,SD.class_desc...
February 14, 2015 at 10:45 pm
TomThomson (2/14/2015)
Eirikur Eiriksson (2/7/2015)
TomThomson (2/7/2015)
Grant Fritchey (2/5/2015)
Really? Yankees fans? Are they even human?Usually not - they're mostly American.
Tom, must say that I find this comment totally inappropriate
😎
How can it...
February 14, 2015 at 11:40 am
Quick answer, NCD (no can do), suggest uninstalling installing and attach the DBs
😎
February 14, 2015 at 8:16 am
Lynn Pettis (2/14/2015)
... Mark one off, 14 days on the calendar to go. 14 days on the calendar to go, 14 days to go, ...
Only two weeks, almost there!
😎
February 14, 2015 at 8:07 am
Further on Luis's post, simply look in the code for the pattern division by a column or a variable such as X / [column_name]
😎
February 13, 2015 at 2:03 pm
Luis Cazares (2/12/2015)
djj (2/12/2015)
Ed Wagner (2/12/2015)
Sioban Krzywicki (2/12/2015)
Eirikur Eiriksson (2/12/2015)
Brandie Tarvin (2/12/2015)
jasona.work (2/12/2015)
Brandie Tarvin (2/12/2015)
jasona.work (2/12/2015)
February 12, 2015 at 2:01 pm
Sioban Krzywicki (2/12/2015)
Ed Wagner (2/12/2015)
Sioban Krzywicki (2/12/2015)
Eirikur Eiriksson (2/12/2015)
Brandie Tarvin (2/12/2015)
jasona.work (2/12/2015)
Brandie Tarvin (2/12/2015)
jasona.work (2/12/2015)
February 12, 2015 at 1:57 pm
Slight side step from Alan's brilliant answer and pitching a retro "blast from the past", here is an example that checks if the root tag has a closing tag, the...
February 12, 2015 at 12:40 pm
Brandie Tarvin (2/12/2015)
jasona.work (2/12/2015)
Brandie Tarvin (2/12/2015)
jasona.work (2/12/2015)
February 12, 2015 at 11:29 am
Quick thought, consider changing the hashing part of the statement as it will not produce unique hash values for every unique combination of input values.
😎
February 12, 2015 at 1:15 am
It would be very interesting to see the execution plan for this code and whoever wrote this code apparently doesn't like the optimizer
😎
February 11, 2015 at 11:11 pm
You are very welcome.
😎
A word of caution, make certain you understand the shortcomings of this code, mainly it neither handles NULL values nor does it guarantee unique values for...
February 11, 2015 at 10:53 pm
cm62597 (2/11/2015)
I have tried that as well you just get Error converting data type varchar to float.
Quick question, can you post the full query and the DDL for the relevant...
February 11, 2015 at 10:32 pm
Quick thought, it makes no sense to use CHECKSUM inside the HASHBYTES function, change CHECHSUM to CONCAT to avoid collisions, consider this example:
😎
SELECT CONVERT(VARCHAR(34),HashBytes('MD5', CONCAT(Col001,Col002,Col003,Col004,Col005,Col006,Col007,Col008
...
February 11, 2015 at 10:26 pm
bmahony993 (2/10/2015)
Its using Execute As "domain\user" currently, and that user is a sys admin
Is "domain\user" password expired?
😎
February 10, 2015 at 12:01 pm
Viewing 15 posts - 6,151 through 6,165 (of 8,754 total)