Viewing 15 posts - 166 through 180 (of 562 total)
What's...
August 11, 2017 at 5:47 am
August 10, 2017 at 8:44 am
August 10, 2017 at 6:35 am
On the site:
https://docs.microsoft.com/en-us/sql/relational-databases/statistics/statistics
"
Consider updating statistics for the following conditions:
June 9, 2017 at 6:46 am
Using the solution provided by Jason A. Long.
May 12, 2017 at 3:01 am
DECLARE @v1 sql_variant;
SET @v1 = '1';
declare @temp table (ID int )
select (case when SQL_VARIANT_PROPERTY(@v1, 'BaseType') in ('varchar','nvarchar','char') then 1 else 0 end)
Try this...
March 10, 2017 at 6:46 am
Dear Reader,
With the above code I a have tried to make a fairly minimalistic CSV generator. When run in SSMS you get a CSV tekst.
It is...
March 10, 2017 at 6:23 am
March 3, 2017 at 8:53 am
;
WITH
Digits0 AS (SELECT n FROM (VALUES ('0'),('1'),('2'),('3'),('4'),('5'),('6'),('7'),('8'),('9'))x(n))
, Digits AS (SELECT CONVERT(VARCHAR(MAX),N) AS c, '%'+CONVERT(CHAR(1),N)+'%' s FROM digits0)
, F AS (SELECT c AS...
March 3, 2017 at 3:25 am
A non-negative integer, containing 'n' unique digits, with no leading zero, has the...
March 2, 2017 at 4:08 pm
Phil Parkin - Thursday, March 2, 2017 11:36 AMOne final attempt and I'll stop: how about 8,877,691?
Yes, this is the anwser I got...
March 2, 2017 at 11:53 am
It's becoming a contest between:
Brain (and calculating)
and
Brute Force.
Phil Parkin can you tel how you came to this anwser ?
Was is Brainpower or Brute...
March 2, 2017 at 11:39 am
Phil Parkin - Thursday, March 2, 2017 10:50 AMIs the total number of rows 8,877,690, by any chance?
It's close.
Ben
March 2, 2017 at 11:28 am
March 2, 2017 at 10:52 am
Viewing 15 posts - 166 through 180 (of 562 total)