Viewing 15 posts - 1,171 through 1,185 (of 8,760 total)
Kenneth.Fisher - Saturday, August 11, 2018 8:02 AMWow, sorry for the massive delay on getting the solution out. Here it is!
He he,...
August 11, 2018 at 9:33 am
Good Morning Experts,
How does the query optimizer(in the relational engine) gets the statistics information...
August 11, 2018 at 9:33 am
Good Morning Experts,
Could you please let me know the logical architecture and physical architecture...
August 11, 2018 at 9:27 am
August 11, 2018 at 6:25 am
This was more for creating a string (not delimited, but same idea). I...
August 11, 2018 at 4:49 am
August 11, 2018 at 4:03 am
We are running a pretty important application on SQL server...
August 11, 2018 at 4:00 am
August 11, 2018 at 3:58 am
Just one thought Steve, you really should ALWAYS schema qualify the CREATE TABLE statement, if only to show a good example 😉
😎
August 11, 2018 at 3:54 am
This can be simplified by using ISNULL and GROUP BY
😎
USE TEEST;
GO
SET NOCOUNT ON;
;WITH SAMPLE_DATA(CONTRACT_NUM,USERNAME) AS
(
...
August 11, 2018 at 3:07 am
Quick thought, for DATETIME2, the default fractional seconds precision is 7, if set to the same as the DATETIME, which is 3, then the result will be 0.
😎
August 11, 2018 at 2:28 am
Joe, you missed out the benefits of a clustered index, speeds up the query many times!
😎
First change:
DECLARE @t table
( Id int...
August 11, 2018 at 1:49 am
How did you get on with this?
😎
Last time I ran into the 7929, I ended up restoring from the latest backups (5 min transaction log backup...
August 11, 2018 at 1:00 am
Geez, I'm stoopid, LOL ..this works but is there a better way
August 10, 2018 at 11:13 pm
Viewing 15 posts - 1,171 through 1,185 (of 8,760 total)