Viewing 15 posts - 361 through 375 (of 423 total)
Ctrl+Shift+R to refresh intellisense local cache.
February 15, 2013 at 8:31 am
Careful with SSMS grids and text output settings chopping the displayed text to 255. Sometimes things are working correctly but display chopped off. I set mine to 8K...
February 12, 2013 at 1:10 pm
Reality appears infinite to me yet all rational viewpoints are finite. I'm not sure any statement can be factually true from all viewpoints. Transcending all viewpoints and becoming...
February 7, 2013 at 12:32 pm
If I purchase an application, I can use it any way I want to. I used to be an academic purist back when I first started in sql 22...
January 31, 2013 at 5:45 am
Here is one that handles all positive ints up to maxint of 10 places. I'd personally turn it into a function and handle negatives too.
declare @days int;
set @days =...
January 30, 2013 at 12:11 pm
Personally I don't mind an overhead of 16k per table in the database. The table could be really wide with lots of columns to handle all your constants. ...
January 28, 2013 at 1:03 pm
Here is a maintainable version...
DECLARE
@dt datetime,
@DayOneDayOfWeek int,
@DaysInMonth int,
@s-2 varchar(200),
@crlf varchar(2)
;
SET @dt = '20130401';
SET @crlf = char(13) + char(10);
-- get max days in month: calculate...
December 28, 2012 at 9:28 am
You can create views to "merge" two tables but they get tricky when you try to update columns from both tables.
You could create a wide table (sparse) containing all the...
December 27, 2012 at 8:32 am
tz.bahrami (12/27/2012)
December 27, 2012 at 7:09 am
Only expose stored procedures as the interface to the front end. Do whatever you like behind the scenes. It is about as object oriented as you can get...
December 26, 2012 at 2:14 pm
Last I knew BCP is incompatible with FULL RECOVERY MODE and I don't fly without a parachute.
We got a huge performance increase by sending a large "multi-row" XML string into...
December 11, 2012 at 2:41 pm
There is no BEST way to do anything since aspects of each situation will vary.
I like your idea of IFs in a stored procedure since each option may be optimized...
November 9, 2012 at 1:52 pm
Consciousness is horrendously bad at multitasking. We must see each viewpoint sequentially. We also generally use the easiest tool for the job so playing with the kids does...
October 11, 2012 at 8:42 am
My article was about the huge milestones in life marked by a radically different point of view center-of-gravity due to learning, experience, boredom, and finally awareness of a higher order....
September 21, 2012 at 1:59 pm
Setting STATISTICS TIME & IO ON will cause severe slowdowns. I generally write each table as a separate SELECT in the FROM clause as above because it always self...
September 10, 2012 at 7:32 pm
Viewing 15 posts - 361 through 375 (of 423 total)