Viewing 15 posts - 3,841 through 3,855 (of 6,038 total)
You can also reference scalar user defined functions within check constraints.
May 26, 2015 at 11:03 am
Confirm there is not a trigger on this table, or some other change data capture mechanism, that inserts into an audit table for which the datatype of Age is still...
May 26, 2015 at 11:00 am
Lynn Pettis (5/26/2015)
itortu (5/26/2015)
SELECT orderno
FROM _order
WHERE CAST(FLOOR(CAST(order_date AS FLOAT)) AS DATETIME)
BETWEEN CAST('5/14/2015' AS DATETIME)
AND CAST('5/15/2015' AS DATETIME)
ORDER BY order_date asc
The...
May 26, 2015 at 10:51 am
Kyrilluk (5/26/2015)
May 26, 2015 at 10:30 am
robin.pryor (5/26/2015)
May 26, 2015 at 9:58 am
Wayne West (5/25/2015)
Ross McMicken (5/25/2015)
GPO (5/23/2015)
May 26, 2015 at 8:01 am
Gary Varga (5/22/2015)
Eric M Russell (5/22/2015)
Gary Varga (5/22/2015)
Eric M Russell (5/22/2015)
T_Peters (5/21/2015)
May 22, 2015 at 10:03 am
Gary Varga (5/22/2015)
Eric M Russell (5/22/2015)
T_Peters (5/21/2015)
May 22, 2015 at 8:03 am
The high level data flow depends on the sequence for which the application calls the stored procedures, so perhaps ask the application team if they have a diagram. Also, running...
May 22, 2015 at 7:34 am
mrl6254 (5/21/2015)
I have been told that numerous applications each today with their own database...
May 22, 2015 at 7:14 am
T_Peters (5/21/2015)
May 22, 2015 at 6:44 am
If you feel confident that this particular query should always leverage the non-clustered columnstore index, then have you tried an index like so?
WITH (INDEX (IX_EmployeeReview_CS))
May 21, 2015 at 11:52 am
Executive managment has requested that available MB disk storage (zero padded to 10 digits) be appended to the end of all server names. You know... as a convenience for the...
May 21, 2015 at 8:17 am
dmbaker (5/21/2015)
Eric M Russell (5/21/2015)
Why is including location in server name important for some?
Because when I'm querying a London server from Seattle, I like to know that I can step...
May 21, 2015 at 7:28 am
Why is including location in server name important for some?
May 21, 2015 at 7:16 am
Viewing 15 posts - 3,841 through 3,855 (of 6,038 total)