Viewing 15 posts - 16 through 30 (of 149 total)
Can anyone think of a use case for a scalar function that simply selects data from other tables?
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
April 3, 2016 at 11:42 pm
should be banned from any respectable SQL Server database?
It's an interesting psychological distinction; that between "is not ideal" and "should be banned". "Should be banned" means the person who...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
April 2, 2016 at 2:35 pm
I'm sure Mr Factor had an evil smirk on his face when he wrote this. The survey results lend weight to my supposition 😉
Having worked in a variety of...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
March 28, 2016 at 7:53 am
Why in the world wouldn't you add this information to the database modelling tool used to design the database and create the build script for it?
Obviously that's the ideal situation,...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
February 25, 2016 at 1:31 pm
Excellent article and some very cogent comments by kenambcrose.
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
February 23, 2016 at 3:15 am
I wonder whether it might have something to do with the way you've structured your original query. It might be worth looking at having a column called "subordinate type" (pet,...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
January 1, 2016 at 3:01 pm
This is a very open-ended question that could take a loooong time to answer well. tl;dr: Know your customers, know the technology, be a team player.
First do some research. Things...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
January 1, 2016 at 12:51 am
You can't dynamically set the position of objects in rdls (sadly). There may be workarounds that go some of the way though depending on how complex the "subreports" are. If...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
December 31, 2015 at 10:34 pm
What does the middle box display? I'm assuming that iif(Globals!PageNumber = Globals!TotalPages, False, True)is in the "Hidden" property of the middle box.
Instead of hiding the middle box have you thought...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
December 31, 2015 at 10:18 pm
Re SSMS shortcuts. I often have BIDS (or whatever it's called this week) open on one screen and SSMS open on another. A few times I've hit F5 thinking SSMS...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
November 11, 2015 at 8:40 pm
It works out the best plan, based on what you want, the distribution and size of the data, and the indexes it can use for your query.
My possibly flawed understanding...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
August 31, 2015 at 4:47 am
I love that you chose the trusty old NOLOCK hint as an example. I started work at a particular organisation many years ago and found the God-like NOLOCKs reverently placed...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
August 3, 2015 at 7:02 am
This is one of the most detailed and thoughtful replies I've seen for a long time. I'm very grateful for the time you put into this and I'm sorry I...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
June 5, 2015 at 6:04 pm
Of course all of this assumes your DBA or sysadmin is beyond reproach. I worked as a bank clerk many years before I'd ever heard of SQL Server. In their...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
May 23, 2015 at 3:24 pm
Er... Is this the right room for an argument?
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
May 18, 2015 at 8:41 am
Viewing 15 posts - 16 through 30 (of 149 total)