Viewing 15 posts - 16 through 30 (of 148 total)
Can anyone think of a use case for a scalar function that simply selects data from other tables?
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...
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...
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,...
February 25, 2016 at 1:31 pm
Excellent article and some very cogent comments by kenambcrose.
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,...
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...
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...
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...
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...
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...
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...
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...
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...
May 23, 2015 at 3:24 pm
Er... Is this the right room for an argument?
May 18, 2015 at 8:41 am
Viewing 15 posts - 16 through 30 (of 148 total)