Browse by Tags
All Tags »
SQL Development (
RSS)
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...
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...
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...
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...
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...
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 (*)...
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...
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 )...
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...
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...
More Posts
Next page »