Viewing 15 posts - 1,861 through 1,875 (of 6,041 total)
Based on feedback, I have submitted an updated version that uses tempdb (lowercase) to compensate for servers with case sensitivity enabled. Also I have extended it to include additional columns...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 9, 2017 at 10:34 am
I don't think you've posted the SQL select statement, but even though the final returned result is only 300k rows, just looking at the execution plan, I'm seeing table spool...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 6, 2017 at 8:53 am
I guess everyone has their own coding standard, but I prefer to place most NOLOCK hints I see between two asterisk / backslash like this:
/* NOLOCK */
😉
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 6, 2017 at 7:29 am
I'd like to renew my Microsoft certification. I routinely work on everything from SQL Server 2005 - 2016 and Azure on a daily basis, but it's hard to believe my...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 6, 2017 at 7:27 am
Steve Jones - SSC Editor (1/5/2017)
Eric M Russell (1/5/2017)
Broadly speaking, I'm free market and libertarian when it comes to cultural freedom and limiting government. However, when it comes to privacy...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 5, 2017 at 1:58 pm
Yeah, go under Help.. About.. menu to see the version of SSMS you're running.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 5, 2017 at 1:28 pm
null
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 5, 2017 at 1:26 pm
null
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 5, 2017 at 1:25 pm
penglin 8198 (1/5/2017)
SQL Server DBA does not seem to pay well, especially for NYC area.
It's unclear whether "City, Country" refers to the location of the employer or the employee /...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 5, 2017 at 1:22 pm
See if the solution mentioned in this post, about setting default program for .sql files, also solves your problem.
.. Installation of SSMS 2012 alongside any other existing SSMS installation, such...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 5, 2017 at 1:10 pm
I try to minimize the amount of complexity within the CATCH block of an error handler. According to MSDN there is no technical reason to explicitly close or deallocate a...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 5, 2017 at 11:18 am
David.Poole (1/5/2017)
In the UK just because a company holds data for one purpose it cannot legally decide to use that data for any...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 5, 2017 at 9:22 am
Similar in concept to Oracle [DUAL] table, it would be useful if SQL Server had a system tally table, perhaps containing only a single INT column with rows from -2,147,483,648...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 5, 2017 at 7:53 am
kast218 (1/4/2017)
Hi, Eric nice query.But one pull request: replace
USE TEMPDB;onUSE tempdb;for case sensitive instance.
Ugh... I've actually never worked with a server that has case sensitivity enabled....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 5, 2017 at 7:41 am
Starting with 2016, all editions of SQL Server (including Express Edition) are essentially feature complete, so there is no reason for this new sample database to leverage only a least...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 5, 2017 at 7:36 am
Viewing 15 posts - 1,861 through 1,875 (of 6,041 total)