Browse by Tags

Taking advantage of Table Variables NOT being transactional - application logging files within a transaction and keeping what's happened

Table Variables are not Transactional, that is to say BEGIN TRAN....ROLLBACK has no effect on them; we can use that to our advantage. Have you ever been in the situation where you use a log file within your application to log progress, unfortunetly because your process is in a transaction you lose what...

Posted to Tony Rogerson's ramblings on SQL Server (Weblog) by tonyrogerson on Tue, Nov 24 2009
SQL 2008 SP1 CU5 is now out and fixes the OPTION(RECOMPILE) Parameter Embedding Optimisation problem - properly!

SQL Server 2008 SP1 Cumulative Update (CU5) link: http://support.microsoft.com/kb/975977/LN/ Details on how they have fully fixed the OPTION( RECOMPILE ) Parameter Embedding Optimisation : http://support.microsoft.com/kb/976603/ What is Parameter Embedding Optimisation, well its basically you can do...

Posted to Tony Rogerson's ramblings on SQL Server (Weblog) by tonyrogerson on Wed, Nov 18 2009
Detecting changed rows in a trigger using HashBytes and without EVENTDATA and OR's

Say you have a table and that table has a secondary history table so you can do windowing, for instance the settings on a specifc entity like the date when we started retaining fees on a debtor account say. Ordinarily most people would resort to a large series of OR's to check the inserted and deleted...

Posted to Tony Rogerson's ramblings on SQL Server (Weblog) by tonyrogerson on Wed, Oct 21 2009
TRUNCATE TABLE transactional?

create table blah ( acol int ) insert blah ( acol ) values ( 1 ) insert blah ( acol ) values ( 1 ) insert blah ( acol ) values ( 1 ) insert blah ( acol ) values ( 1 ) begin tran truncate table blah select COUNT (*) from blah rollback select COUNT (*) from blah drop table blah So, yes - it is subject...

Posted to Tony Rogerson's ramblings on SQL Server (Weblog) by tonyrogerson on Sat, Sep 5 2009
Testing Stored Procedures and Triggers - Using CHECKSUM to write effective test scripts for Stored Procedures and Triggers

Stored procedure and Trigger testing can be very easily compartmentalised into individual test scripts and fully automated by taking advantage of the CHECKSUM function – no more writing hoodles of IF statements to check each scenario – just write the query, if its changed the CHECKSUM on the results...

Posted to Tony Rogerson's ramblings on SQL Server (Weblog) by tonyrogerson on Wed, Jul 22 2009
SQL Server Technical Roll up for July 2009

Thanks to Vicki Collins for this technical rollup; some interesting stuff to check out... News Microsoft Releases SQL Server 2008 Service Pack 1 Microsoft has released SQL Server 2008 Service Pack 1 with enhancements meant to ease deployment but no brand new features. http://www.eweek.com/c/a/Database...

Posted to Tony Rogerson's ramblings on SQL Server (Weblog) by tonyrogerson on Mon, Jul 6 2009
Tonight on LiveMeeting -> SQL 2008 R2 and Gemini; From Data Modelling to Information Architecture and Attribute Relationships, Aggregations and using MDX Studio to its best

We are broadcasting tonights UK SQL Server User Group meeting in Reading, for more information go to http://sqlserverfaq.com/events/168/SQL-2008-R2-and-Gemini-From-Data-Modelling-to-Information-Architecture-and-Attribute-Relationships-Aggregations-and-using-MDX-Studio-to-its-best.aspx . The agenda.....

Posted to Tony Rogerson's ramblings on SQL Server (Weblog) by tonyrogerson on Wed, Jun 10 2009
Job in Bristol; MS SQL Server DBA OLAP developer - Permanent.

There is a job going in Bristol (see below), if you are interested and experienced enough for the role then please email me tonyrogerson@sqlserverfaq.com and I'll forward your details onto the agent - note; obviously - do so before the end of June 2009 as google will index this and the job position...

Posted to Tony Rogerson's ramblings on SQL Server (Weblog) by tonyrogerson on Wed, Jun 10 2009
LiveMeeting recording for my SQL Server Toolset intro (part 1) is now available

The first in my live meeting series was on SQL Server Basics - Part 1 : An introduction to the SQL Server toolset. The recording is available here: http://sqlserverfaq.com/livemeetings/sqlfaq_20090528_tonyrogerson_sqlserverbasics_tools.zip I pretty much covered the following: >> Common tools you...

Posted to Tony Rogerson's ramblings on SQL Server (Weblog) by tonyrogerson on Thu, May 28 2009
SQL User Group - tonight is Edinburgh; tomorrow a Live Meeting on the SQL Server toolset

Don't forget tonight is the Edinburgh user group meeting ( http://sqlserverfaq.com?eid=174 , if you've already registered then see you there - Martin Bell is your host this evening. Tomorrow afternoon I'm doing a Live Meeting ( http://sqlserverfaq.com?eid=175 ) on the product tools at an...

Posted to Tony Rogerson's ramblings on SQL Server (Weblog) by tonyrogerson on Wed, May 27 2009

Page 1 of 4 (31 items) 1 2 3 4 Next >