Browse by Tags
All Tags »
SQL Server (
RSS)
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...
Andrew Fryer has done a number of blog posts on Virtualisation for DBA's for SQL Server - very good and informative. http://blogs.technet.com/andrew/archive/2009/10/16/virtualisation-for-the-dba-part-1-are-you-bovvered.aspx http://blogs.technet.com...
There is so much out in the cosmos for helping with the manageability of SQL Server, this particular download from Microsoft is the early concept that later became the Management Data Warehouse in SQL Server 2008 which frankly is way cool. Anyway - this...
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...
Lots of really useful information: http://support.microsoft.com/kb/2001270/en-us A must read for anybody with or considering using database mirroring. Tony.
Don't forget tomorrow night is the first Cardiff based user group meeting where I will present on Ensuring Business Continuity (Backups, Mirroring and Monitoring) and Allan Mitchell will do SQL 2008 Integration Services - some of the things that make...
Note that I will be going into more detail in a series of 30-40 minute LiveMeetings starting towards the end of October, please see sqlserverfaq.com for more information - I'll be posting the info this weekend so check back after then. The session...
Quite a lot to cover in 45 minutes but my plan is to overview the areas in demo and a one slider and then attack each area from the beginning of October in more detail on LiveMeeting - going to sort the dates over the weekend. Here is the new abstract...
Don't forget this Wednesdays user group at Microsoft in Reading, please visit http://sqlserverfaq.com?eid=169 to register; briefly we have Clive Challinor, SQL Core Escalation Engineer and Daniel Sol, SQL Server Technical Support Engineer talking...
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 (*)...
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...
If you want to see how far along your restore or backup is then you can do this... select percent_complete from sys . dm_exec_requests where session_id = 53 This is in addition to the STATS = n option on the BACKUP/RESTORE commands.
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...
More Posts
Next page »