Viewing 15 posts - 181 through 195 (of 392 total)
SELECT a.*
FROM dbo.ComplexQuery AS a
WHERE COUNT(DISTINCT ColumnD) OVER(PARTITION...
March 3, 2017 at 5:28 am
March 3, 2017 at 5:27 am
While I've most likely forgotten a number of them, these are the ones that stick out in my mind most readily:
BASIC (DEC...
February 24, 2017 at 6:53 am
If, however,...
February 10, 2017 at 3:16 pm
Since Steve was kind enough to re-post this in today's daily email, I just now was able to read this posting. Nice job Gail!
While the purpose of the...
February 10, 2017 at 1:28 pm
Blech! I knew the right answer but clicked the wrong option. Goes to prove that jumping too quickly to answer without double-checking can be hazardous!
January 4, 2017 at 5:40 am
The team did identify a method of pushing the data to SQL Server but this approach requires coordinating the stored procedure execution on SQL Server to occur AFTER the data...
December 5, 2016 at 9:31 am
That's the thing I like about you Jeff. You're always full of optimism and hope! 😛
However, I've not given up hope yet. Who know, since support for XML...
December 5, 2016 at 9:17 am
Carlo Romagnano (9/22/2016)
Aaron N. Cutshall (9/22/2016)
September 22, 2016 at 7:59 am
I got the responses correct except that I also included "Command(s) completed successfully." -- which does flash briefly due to the master table creating successfully (doing them individually shows that...
September 22, 2016 at 6:56 am
BrainDonor (9/16/2016)
They are defaults within Tools/Options/SQL Server Object Explorer/Commands (in SSMS 2014 - may be elsewhere in other versions) and therefore configurable.
This affects the defaults within SSMS sessions for the...
September 16, 2016 at 6:18 am
xsevensinzx (9/1/2016)
At what point do you stop and launch? When is done, done?
Don't get me wrong. I'm not saying that we need to spend lots of time in planning...
September 1, 2016 at 11:35 am
chrisn-585491 (9/1/2016)
Design choices that impact the database matter.
I totally agree. As a data architect, I get frustrated when development managers are only concerned with right now and eschew data...
September 1, 2016 at 6:36 am
Ralph Hightower (8/30/2016)
Switching the patient lookup to a stored procedure increased the performance of that phase of the application by 25%.
Ralph, it's all in how the stored procedure was written...
August 30, 2016 at 7:06 am
One of the issues I've found with ORM frameworks is that it trains one into a particular way of thinking. For example, I worked on a project that was...
August 30, 2016 at 6:47 am
Viewing 15 posts - 181 through 195 (of 392 total)