Viewing 15 posts - 3,391 through 3,405 (of 7,614 total)
May 10, 2018 at 10:24 am
Also, don't you want to subtract 1 from the substring length to you get rid of the period and everything after it in the string (that seems to me to...
May 10, 2018 at 9:50 am
As always, clustering key is the most critical thing.
Do you (almost) always specify the deal_id when reading the dbo.avt_deal_restriction table? If so, cluster that table on ( deal_id,...
May 9, 2018 at 2:03 pm
May 9, 2018 at 7:40 am
Unless you pre-build a combined table of all the sys.objects 'FN' entries for each db, you won't be able to do this. AFAIK, you can't get the object type and...
May 8, 2018 at 2:43 pm
May 8, 2018 at 11:30 am
CREATE TRIGGER [trg_srv_audit_DDL_Event]
ON ALL SERVER
WITH EXECUTE AS '<login_name>' /* replace with your own login_name with authority to write to audit table, etc. */
May 8, 2018 at 10:13 am
Yeah, you must use colons instead of dots in the time. I'm used to seeing either one ... but SQL isn't.
SELECT CAST('20180326 05:00:00' as datetime2)
May 7, 2018 at 3:58 pm
There must be a trigger(s) on the table that is incorrectly handling a date string (?).
May 7, 2018 at 3:49 pm
Viewing 15 posts - 3,391 through 3,405 (of 7,614 total)