Viewing 15 posts - 166 through 180 (of 984 total)
You changed the WHERE clause as well?
Thomas Rushton
blog: https://thelonedba.wordpress.com
January 11, 2018 at 5:48 am
Missed that bit, sorry.
This is always a problem when converting between strings and dates, and is avoided by using ISO 8601 format date strings, putting the...
Thomas Rushton
blog: https://thelonedba.wordpress.com
January 11, 2018 at 5:27 am
Try AND rather than OR in your HAVING clause?
Thomas Rushton
blog: https://thelonedba.wordpress.com
January 11, 2018 at 5:16 am
There's an interesting take on the problem from the ICO (the Information Commissioner's Office in the UK), linking this to GDPR, and the responsibility to patch systems regularly.
Thomas Rushton
blog: https://thelonedba.wordpress.com
January 9, 2018 at 9:47 am
Thomas Rushton
blog: https://thelonedba.wordpress.com
January 8, 2018 at 2:15 am
Thanks Steve. Can you please link to the MS KB for SQL Server? https://support.microsoft.com/en-us/help/4073225/guidance-for-sql-server
It looks as though you meant to in this passage:
Thomas Rushton
blog: https://thelonedba.wordpress.com
January 5, 2018 at 4:17 am
Thomas Rushton
blog: https://thelonedba.wordpress.com
January 4, 2018 at 1:35 am
It's my fault... I was incorrectly only looking at the number of ounces. ...
Thomas Rushton
blog: https://thelonedba.wordpress.com
December 30, 2017 at 6:40 am
Hmm.
What do you get from the following queries?
SELECT * FROM Enrollment WHERE Grade IN ('PK','KG','01','02')
SELECT Grade, COUNT(*) FROM Enrollment GROUP BY Grade
Thomas Rushton
blog: https://thelonedba.wordpress.com
December 22, 2017 at 4:31 am
There's a Connect item to increase / remove the file size limit for sqlcmd - https://connect.microsoft.com/SQLServer/feedback/details/1844733/sqlcmd-exe-file-size-limit-is-2-gb
Thomas Rushton
blog: https://thelonedba.wordpress.com
December 19, 2017 at 2:55 am
I've sent a message over to one of the Redgaters who looks after this sort of thing.
Thomas Rushton
blog: https://thelonedba.wordpress.com
December 19, 2017 at 2:44 am
Good Morning Experts,
Application users have reported slowness. We checked SQL Server CPU and its...
Thomas Rushton
blog: https://thelonedba.wordpress.com
December 15, 2017 at 4:14 am
or maybe just use ROW_NUMBER() OVER (PARTITION BY CustomerID ORDER BY OrderDate)
It looks as though it should be ASC rather then DESC sorting? I could, of course, be...
Thomas Rushton
blog: https://thelonedba.wordpress.com
December 15, 2017 at 3:01 am
Was this database part of an availability group? There's a thing about lazy recycling of transaction log VLFs that might be what's causing problems / concerns. https://blogs.msdn.microsoft.com/sql_pfe_blog/2013/06/27/lazy-log-truncation-clearing-of-sql-transaction-log-vlf-status-deferred/
Thomas Rushton
blog: https://thelonedba.wordpress.com
December 14, 2017 at 4:59 am
I've just reproduced the problem with SQLCMD... 😀 - that just returns "A"
Not got SSMS 17.4; got the problem when running with SSMS 17.3.
The full string...
Thomas Rushton
blog: https://thelonedba.wordpress.com
December 12, 2017 at 9:44 am
Viewing 15 posts - 166 through 180 (of 984 total)