Browse by Tags

Removing blank line in SSMS (Management Studio) Find and Replace dialogue

Yes, copying between word and email always puts an extra line between code lines which makes the code hard to read. The answer is simple; in Management Studio go into Find and Replace, in "Find Options" check "Use" and select "Regular Expressions". Now, in the Find what...

Posted to Tony Rogerson's ramblings on SQL Server (Weblog) by tonyrogerson on Mon, Jan 11 2010
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
Another row concatenation example

I had an email today wanting a solution to a row concatenation problem, for those who already know where this is going - yes, its FOR XML, anyway.... Consider the data source: PRODUCT PROCESS TOP BOTTOM RIGHT LEFT GLASS 1 CUTTING GLASS 1 BEVELLING YES YES GLASS 1 GRINDING YES YES GLASS 1 POLISHING YES...

Posted to Tony Rogerson's ramblings on SQL Server (Weblog) by tonyrogerson on Sat, Oct 17 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
Using CTE (Common Table Expression) and Views to generate data

I'm writing a new content area on http://sqlserverfaq.com/ to hold our LiveMeeting recordings and the other content we have and I wanted to create a short character/digit code that you can put on the end of the domain eg http://sqlserverfaq.com/FGRE2 that shorts the URL so you can go straight to...

Posted to Tony Rogerson's ramblings on SQL Server (Weblog) by tonyrogerson on Wed, Aug 12 2009
Understanding SQL Server Certification and Learning Technologies from Microsoft Learning

Don't forget this Monday evening Chris Testa-O'Neill has secured from Microsoft Corp - Ken Jones, Gerry O'Brien and Joseph Sack to talk to us about Understanding SQL Server Certification and Learning Technologies from Microsoft Learning ). This will be a session using the online LiveMeeting...

Posted to Tony Rogerson's ramblings on SQL Server (Weblog) by tonyrogerson on Fri, Aug 7 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

Page 1 of 5 (41 items) 1 2 3 4 5 Next >