Viewing 15 posts - 31 through 45 (of 49 total)
It would be great if stock market activity was evenly distributed throughout the day but the actual profile has huge spikes. Here in the US, normal market hours are...
April 22, 2013 at 5:48 am
DECLARE @dt datetime
SELECT @dt = GETDATE()
SELECT CONVERT( DATETIMEOFFSET, @dt, 'CST')
and Iād get my current time in Central Standard Time (CST).
I don't know where...
July 17, 2012 at 6:34 am
Level 8 is in the pipeline. I just submitted a draft for technical review so hopefully I won't keep you waiting much longer š
July 8, 2012 at 11:35 pm
Hi, Sujeet.
Sorry for the confusion but I'm in the process of making some last minute changes to Level 7 of this Stairway. My day job sometimes gets in the...
January 18, 2012 at 5:54 am
Hi, Jon.
Thanks for the positive feedback. Iām glad you found this Stairway informative.
It looks like you are using SQL 2005, which is a bit pickier regarding the bit data...
January 6, 2012 at 6:38 am
Stephen E. Cook (11/12/2011)
But then what would they publish on TheDailyWTF.com? š
As much as I hate to admit it, I've had the dubious honor of having my code showcased on...
November 12, 2011 at 7:33 am
Our large database development team performs peer code reviews using a code review tool (http://smartbear.com/products/development-tools/code-review/). When we first started the process, it surprised me that some developers...
November 12, 2011 at 6:57 am
Thanks for pointing out the missing spaces in the script. The edit tool didn't preserve the original spaces so I added them back. The revision is awaiting appoval.
October 22, 2011 at 1:56 pm
SQL Server allows a foreign key to reference any column(s) that is guaranteed to be unique. The Books Online states "FOREIGN KEY constraints can reference only columns that are...
October 21, 2011 at 7:13 pm
I corrected the script in the article shortly after Sammesel brought this to my attention. As I mentioned in my other response, the other issue is that the script...
October 21, 2011 at 6:41 pm
There are so many facets to SQL Server nowadays that I think it's ludicrous to expect even the foremost expert to fully understand the entire product and it's nuances. ...
August 23, 2011 at 10:22 pm
The Server-side Tracing stairway is targeted at SQL 2005 and later versions. Since the error message refers to the CROSS APPLY line, I suspect you are either running this...
August 4, 2011 at 7:02 am
You should be able to select from a remote trace file with fn_trace_gettable using a UNC path without problems. I just ran a cursory test and had no problems...
July 25, 2011 at 6:05 pm
Hi, Toby.
I also wish sp_trace_create had an option to overwrite an existing file. I'm not a big fan of file manipulation in T-SQL either.
You might consider making...
February 23, 2011 at 9:03 pm
Rony, I'll cover the sp_trace* procs in detail in the next Stairway level, How to Create a SQL Trace Using T-SQL.
With client-side traces, a SQL Trace rowset provider runs on...
February 23, 2011 at 8:31 pm
Viewing 15 posts - 31 through 45 (of 49 total)