• Check Script

    Updated: 2010-06-30 15:10:04
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in Buck Woody Entire Site Search Home Blogs Forums Downloads Opml Buck Woody Carpe Datum Check Script Someone contacted me yesterday and said they were getting blocked when they tried to create a FileStream data column type . On investigation , I found they were Mirroring that database and the two aren’t . compatible Which got me to thinking it’s probably a good idea to make a check script” as you investigate tacking on a new feature , column type and so on to ensure that they are compatible with what you want to do . For instance , in the case of the client that contacted me , I just ran this script as part of the troubleshooting process : SELECT FROM sys database_mirroring GO

  • Another bin-packaging algorithm using recursion and XML

    Updated: 2010-06-30 12:42:00
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in Peter Larsson Entire Site Search Home Blogs Forums Downloads Opml Peter Larsson Thinking outside the box Another bin-packaging algorithm using recursion and XML This time I will show you an algorithm to do the dreaded bin-packaging using recursion and . XML First , create some sample data like this Prepare sample data DECLARE Sample TABLE RowID INT IDENTITY 1 1 PRIMARY KEY CLUSTERED Expense SMALLMONEY NOT NULL Populate sample data INSERT Sample Expense VALUES 12.51 45.63 66.35 92.66 65.46 54.01 32.23 27.16 78.92 14.58 Next , we need to create a variable to hold the user's wanted total . sum Prepare user supplied parameter DECLARE WantedSUM SMALLMONEY 111.09 And we also need

  • SQLAuthority News – A Monthly Round Up of SQLAuthority Blog Posts

    Updated: 2010-06-30 02:30:01
    Last month I wrote monthly round up and I was very well received. For the same here it goes this months wrote up for all the SQLAuthority.com blogs. The month started very interesting subject of SQL SERVER – Precision of SMALLDATETIME – A 1 Minute Precision which lead to few datetime related blog posts. I find [...]

  • Clustering Utility Made Available by Microsoft

    Updated: 2010-06-30 01:02:49
      The CSS team just made me aware of a new utility for cluster’s called the Remote Desktop Connection Manager. I don’t want to just repeat what has already been said so go ahead and have a look here for the details: http://blogs.msdn.com/b/clustering/archive/2010/06/23/10028855.aspx Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!...(read more)

  • PASS Summit 2010 – BI Workshop

    Updated: 2010-06-30 01:01:10
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in Davide Mauri Entire Site Search Home Blogs Forums Downloads Opml Davide Mauri A place for my thoughts and experiences on SQL Server , Business Intelligence and NET PASS Summit 2010 BI Workshop PASS Summit 2010 Pre Post conference are out This year I’ll deliver the Creating BI Solution from A to Z seminar in which , as the title implies , attendees will see how to create a BI solution starting from scratch . Going through the dimensional modeling and the creation of the Datawarehouse , the implementation of the ETL process with SSIS , the creation of cube with Analysis Services and reports with Reporting Services with , if time permits , also a glance at PowerPivot , attendees

  • Anyone running Thin Provisioned storage?

    Updated: 2010-06-29 21:51:00
    A friend recently asked me for some advice about implementing SAN storage for SQL Server, and I was able to explain how we'd implemented our storage, but ours is a more traditional setup with static LUNs tied to specific physical disks. Anyone out there have real-world experience running production SQL Server on thin provisioned storage instead? Success? Tips? Failure? I get the idea in the abstract, but have never really had my hands on a system like that. Share this post: email it! | bookmark it!...(read more)

  • Hide the Date column whenever you define a Dates table in PowerPivot

    Updated: 2010-06-29 16:13:17
    There are already several posts in the blogosphere about the need of using a separate Dates table in PowerPivot to make almost any type of analysis. An important step you should make whenever you have a Dates table (almost always, in theory!) is to hide the Date column of the table containing measures in the Pivot Table. For example, suppose you define these measures, having a Balances table and a Dates table in your PowerPivot model: ClosingBalanceMonth = CLOSINGBALANCEMONTH( SUM( Balances[Balance]...(read more)

  • The Windows Page File and SQL Server

    Updated: 2010-06-29 14:48:00
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in Buck Woody Entire Site Search Home Blogs Forums Downloads Opml Buck Woody Carpe Datum The Windows Page File and SQL Server What is the best Page File” size for a Windows system running SQL Server I see this question over and over and I see people answering it incorrectly all the time . Note : I’m talking specifically about 64-bit architectures here . The information is different for 32-bit architectures , but I’ll blog about that at another . time First , let’s start out with defining a few terms . A Page File” is simply a file on the hard drive that handles situations where the system wants to move or page out” sections of memory . There are several situations that cause

  • Perfection vs. Precision

    Updated: 2010-06-29 12:00:00
    Introduction This post is the twentieth part of a ramble-rant about the software business. The current posts in this series are: Goodwill, Negative and Positive Visions, Quests, Missions Right, Wrong, and Style Follow Me Balance, Part 1 Balance, Part 2 Definition of a Great Team The 15-Minute Meeting Metaproblems: Drama The Right Question Software is Organic, Part 1 Metaproblem: Terror I Don't Work On My Car A Turning Point Human Doings Everything Changes Getting It Right The First Time One-Time...(read more)

  • Christian’s book – not just Brent’s

    Updated: 2010-06-29 05:55:09
    I like to joke with Christian Bolton ( @christianbolton ) about the time when he got accused of claiming to have written Brent’s book . Of course, he didn’t write Brent’s book – Brent wrote some of Christian’s. And it’s an excellent book. For a start, I should point out that I know several of the authors. Christian’s a great guy who lives about 2 miles from my grandparents . Amongst the other authors, there are fellow Arsenal supporter James Rowland-Jones , presenter-extraordinaire and exceptional...(read more)

  • Take it to the MAX (and beyond)

    Updated: 2010-06-29 05:54:07
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in Extended Events Entire Site Search Home Blogs Forums Downloads Opml Extended Events Take it to the MAX and beyond I got an interesting question from our Support team today and thought I’d blog the answer since it identified an area that can easily cause some confusion . In the BOL documentation for CREATE EVENT SESSION the description for the MAX_MEMORY session option states the : following Specifies the maximum amount of memory to allocate to the session for event buffering The default is 4 MB . size is a whole number and can be a kilobyte kb or a megabyte MB value . Underline is mine . An observant Extended Events user noticed that their event session appeared to be using

  • SQL SERVER – Outer Join Not Allowed in Indexed Views

    Updated: 2010-06-29 02:30:11
    I recently received an email that contains a question from one of my readers. I have already replied the answer to his email, but I would still like to bring it to your attention and ask if you think I could have done any better with the example I gave. The question was raised when [...]

  • SQLAuthority News – Exam 70-433 – MCTS – Microsoft SQL Server 2008, Database Development

    Updated: 2010-06-29 02:30:06
    I often receive lots of questions regarding how to pass SQL Server Certification exams. I have previously written about the road map over SQL SERVER – Roadmap of Microsoft Certifications – SQL Server Certifications. I have tremendous respect for Microsoft Certification and I enjoy the preparation phase as well as attending the real exam. The [...]

  • Master Data Services first cumulative update is now available!

    Updated: 2010-06-28 23:41:15
    We have assembled a new release that addresses a number (30+) of issues that we could not address before the SQL Server 2008 R2 RTM release.  Everyone who is seriously considering Master Data Services or even kicking the tires is encouraged to take this update.  Anyone actively using the product is encouraged to take this release as well. Here is the location of the KB Article: http://support.microsoft.com/kb/2143880 Note: This is a full installation msi.  You can install this MSI...(read more)

  • In-Memory Databases (IMDBs)

    Updated: 2010-06-28 14:10:00
    Even those of us who were never good at math can tell that the CPU is outpacing the other system components. Two recent developments are helping to change that equation: SSDs and IMDBs....(read more)

  • Using SpeakerRate.com

    Updated: 2010-06-28 12:00:00
    I've been using SpeakerRate.com to gather feedback on my presentations. If you attended my sessions at CodeStock last week, please rate them. If you're speaking regularly at Code Camps or SQL Saturdays , feedback is cool. If you're new to presenting, it's essential! :{> Andy Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!...(read more)

  • Looking for a Sydney-based Mentor for SolidQ Australia

    Updated: 2010-06-28 08:21:00
    Hi Folks, Just a short note to let you know we're keen to find another mentor for Australia with a strong preference for one based in Sydney. This would work best for someone with very strong SQL skills, good consulting skills and likely an existing independent consultant. Ping me if you'd like to discuss it further. Regards, Greg Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!...(read more)

  • PASS Chapter map

    Updated: 2010-06-28 06:11:00
    Displaying information on an interactive map really isn’t that hard to do. My friends John & Bronwen have been doing this stuff for ages through their company Soul Solutions , and have done lots of talks about how to do this. They have the ability to take that stuff far beyond what I can, but as it’s a significant aspect of data visualisation, it’s an area in which I like to be fairly fluent. I wrote a blog post last month on how to fetch latitude and longitude values for addresses , which I...(read more)

  • Did You Know: My next web seminar is this Wednesday!

    Updated: 2010-06-28 04:40:00
    I know, I haven't made a geeky post in a while... but I promise that I'll do one after this seminar. I'll take some of the best questions that I get during the chat and write them up here. Query Plans Workshop (June 30, 2010) Learn about basic elements, tools for exploring your query plans, how to detect inefficient plans and best practice guidelines The workshop starts at 9 in the morning Pacific Time,and I'll be available on live chat to answer questions during the broadcast. Thanks! ~Kalen Share...(read more)

  • SQL SERVER – Default Statistics on Column – Automatic Statistics on Column

    Updated: 2010-06-28 02:30:33
    During the SQL Server Training, I frequently noticed confusion in people in terms of Statistics. Many people have no idea on how Statistics works. There are so many misconceptions with respect to Statistics. I recently had an interesting conversation with one attendee who believed that Statistics only exists on Column if there is an Index [...]

  • A problem I must solve about speaking

    Updated: 2010-06-28 01:13:36
    So I am back hotel (yeah, not I won’t be “back home” until the 4th most likely) after speaking in Columbus yesterday, and I feel like blogging about how things went, perhaps to get advice on how you might correct/approach things.  I do two sessions usually, a design fundamentals session that went well, with scores averaging 4ish out of 5. No real “bad” reviews, and a few pretty good ones. Then I looked through the reviews for the Patterns session and a few were pretty great, but a few more were...(read more)

  • Analysis Services Data Connections and SharePoint - One Solution to "Connection Cannot Be Made"

    Updated: 2010-06-27 19:56:00
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in Stacia Misner Entire Site Search Home Blogs Forums Downloads Opml Stacia Misner Analysis Services Data Connections and SharePoint One Solution to Connection Cannot Be Made Recently I came across a problem with an Analysis Services data connection when I was trying to create a status indicator in SharePoint 2010 formerly known as a key performance indicator in SharePoint 2007 I had successfully created the data connection in Excel , verified that I could create a PivotTable with it , and then saved the connection to Excel Services as an Office Data Connection ODC file . However , when I tried to use the ODC to create a status indicator , the following error : displayed A

  • SQLAuthority News – Announcing Winners of the Office 2010 Giveaway

    Updated: 2010-06-27 02:30:32
    Thank you all for participating in Office 2010 giveaway. After carefully evaluation following user is announced as the winner. The question was as following. Choose best option: With which Microsoft Office Product Powerpivot is associated? Options: 1) PowerPoint 2) Excel 3) Word The answer was suppose to be most creative and informative. Many congratulations to [...]

  • Operator of the Week - Index Spool

    Updated: 2010-06-26 12:33:55
    If you've ever wondered what happens to your queries if you're not conscientious about creating indexes, then Fabiano Amorim has yet another nugget of Execution Plan wisdom for you. The Query Optimizer's solution is to use the Nonclustered Index Spool, and we're about to learn why.

  • SQL SERVER – Fast Track Data Warehouse for SQL Server 2008

    Updated: 2010-06-26 02:30:07
    I recently attended a wonderful training session organized by Microsoft on Fast Track Data Warehouse Reference Architectures. If you are regular reader of my blog, you will be well aware of the fact that I am more of the Relational guy than a Business Intelligence professional. I was initially a bit skeptic about this training. [...]

  • Don't Do This

    Updated: 2010-06-25 16:14:00
    In working on applications at client sites you tend to come across code that makes you think "what were they thinking"? This week I found one that just made me do the "facepalm": select top 1 @_StateTrueKey = OverEngineeredKey from OverEngineered where Value = 'true' select top 1 @_StateFalseKey = OverEngineeredKey from OverEngineered where Value = 'false' (The names have been obviously obfuscated.) When I saw this I had to look at the table contents: OverEngineeredKey Value 0 False 1 True OK, it's...(read more)

  • Institutionalized!

    Updated: 2010-06-25 12:00:00
    Introduction This post is the nineteenth part of a ramble-rant about the software business. The current posts in this series are: Goodwill, Negative and Positive Visions, Quests, Missions Right, Wrong, and Style Follow Me Balance, Part 1 Balance, Part 2 Definition of a Great Team The 15-Minute Meeting Metaproblems: Drama The Right Question Software is Organic, Part 1 Metaproblem: Terror I Don't Work On My Car A Turning Point Human Doings Everything Changes Getting It Right The First Time One-Time...(read more)

  • SQLAuthority News – Download – Microsoft SQL Server 2008 R2 Best Practices Analyzer

    Updated: 2010-06-25 02:30:01
    Microsoft has released wonderful tool SQL Server 2008 R2 Best Practices Analyzer. I have previously used this tool and found it quite helpful. Here is the latest version which you can download from MS site. Microsoft SQL Server 2008 R2 Best Practices Analyzer However, I received quite a few emails that users are not able [...]

  • PowerShell Script to Remove Old Backups

    Updated: 2010-06-24 17:46:00
    A Twitter user asked for a script to remove old backups, and I had one I built back in February, so here it is (use at your own risk): #rmbackup.ps1 # Removes database and transaction log backups # # Change log: # February 2, 2010: Allen White # Initial Version # Get the SQL Server instance name from the command line param( [string]$inst=$null, [int]$days=$null ) # Load SMO assembly, and if we're running SQL 2008 DLLs load the SMOExtended and SQLWMIManagement libraries $v = [System.Reflection.Assembly]::LoadWithPartialName(...(read more)

  • How I lay out my T-SQL source code

    Updated: 2010-06-24 16:26:00
    I have a Visual Studio solution which mostly consists of unit and automated tests. All tests are developed in C#, using NUnit and our own library for database tests . All my T-SQL code is also included in the same VS solution. Because Windows search frequently fails to find files, I am using VS search, which always finds all the right files as long as they are included in my solution. This also allows me to find both a module's source code and the corresponding unit tests, which is very convenient....(read more)

  • Oracle to SQL Server, Crossing the Great Divide, Part 3

    Updated: 2010-06-24 14:55:17
    We soon learn, in SQL Server, that heaps are a bad thing, without necessarily understanding how or why. Jonathan Lewis is an Oracle expert who doesn't like to take such strictures for granted, especially when they don't apply to Oracle. Jonathan discovers much about how SQL Server places data, and concludes from his experiments that heaps perform badly in SQL Server because you cannot specify a fill factor for them.

  • Binary Trees in SQL

    Updated: 2010-06-24 14:55:16
    A number of hierarchies and networks are most convenently modelled as binary trees. So what is the best way of representing them in SQL? Joe discards the Nested Set solution in favour of surprisingly efficient solution based on the Binary Heap.

  • Developing Modifications that Survive Concurrency

    Updated: 2010-06-24 14:55:15
    You can create a database under the assumption that SQL looks after all the problems of concurrency. It will probably work fine under test conditions: Then, in the production environment, it starts losing data in subtle ways that defy repetition. It is every Database Developer's nightmare. In an excerpt from his acclaimed book, Alex explains why it happens, and how you can avoid such problems.

  • UPDATE Basics in SQL Server

    Updated: 2010-06-24 14:55:14
    SQL Server's UPDATE statement is apparently simple, but complications such as the FROM clause can cause puzzlement. Bob Sheldon starts simply, and introduces the more complex forms painlessly.

  • SQLAuthority News – Meeting Bryan Oliver and Learning Wisdom of Life

    Updated: 2010-06-24 02:30:45
    During my most recent travel outside India, I was fortunate enough to meet Bryan Oliver. I have heard a lot about him but never had chance to meet him in person. Just like we all do for someone we never met before, I had already some preconceived notions about him. I assumed that he might [...]

  • SQLAuthority News – Guest Post – SELECT * FROM XML – Jacob Sebastian

    Updated: 2010-06-23 02:30:22
    One of the most common problem SQL Server developers face while dealing with XML is related to writing the correct XPath expression to read a specific value from an XML document. I usually get a lot of questions by email, on my blog or in the forums which looks like the following: “I have the [...]

  • SQLAuthority News – Price List – Oracle vs SQL Server

    Updated: 2010-06-22 02:30:44
    During one of the consulting project, I was asked to prove that the SQL Server is a more economical choice than Oracle. Well, I do not want to start again the battle, which has been clearly won by SQL Server. Summary: SQL Server is a feature-rich and economical choice compared to Oracle. The base product [...]

  • SQLCLR debugging and VS 2010 revisited

    Updated: 2010-06-21 23:21:00
    Home Syndication Log in SQLCLR debugging and VS 2010 revisited In my blog entry from about a month and a half ago , I summarized my finding on using Visual Studio 2010 with SQLCLR , and the partial support of SQL Server 2008 new features . One feature with the disclaimer that's it's not preferred supported that I thought I'd lost was attach to process style debugging with SQLCLR . And that I hadn't discovered the secret sauce that makes this work . Here's the secret sauce . Robert Bruckner's blog entry about debugging SSRS add-ins mentions that there are now two debug engines inside Visual Studio 2010, one for NET 2.0 3.0 3.5, and the other for 4.0 only To debug SQLCLR which uses NET 2.0 3.5 with attach to process we need a config file like the one Robert posted for reporting services .

  • SQL SERVER – TRANSACTION, DML and Schema Locks

    Updated: 2010-06-21 02:30:23
    Today we will be going over a simple but interesting concept. Many a time, I have come across the lack of understanding on how the transactions work in SQL Server. Today we will go over a small but interesting observation. One of my clients had recently invited me to help them out with an interview [...]

  • SQL SERVER – Free Download – SQL Server 2008 R2 Update for Developers Training Kit

    Updated: 2010-06-20 02:30:42
    SQL Server 2008 R2 is released and have been a stable product since the day it is released. I have not received any complains or rants from any of my customers who has upgraded to this version. The number one request is how one can learn about the new features of SQL Server or how [...]

  • SQLAuthority News – Delivering Two SQL Sessions at SQL Data Camp at Chennai – July 17, 2010

    Updated: 2010-06-19 02:30:36
    SQL Server Community is very strong community world-wide. In India SQL is considered as one of the most popular technology. Chennai is the only city in India where there are more than 3 SQL Server MVPs are from. My MVP friends has arranged one of the very first whole day SQL event in India at [...]

  • SQLAuthority News – Interview with SQL Server MVP Madhivanan – A Real Problem Solver

    Updated: 2010-06-18 02:30:05
    Madhivanan (SQL Server MVP) is a real community hero. He is known for his two skills – 1) Help Community and 2) Help Community. I have met him many times and every time I feel if anybody in online world needs help Madhivanan does his best to reach them out and solve problem. His name [...]

  • SQL SERVER – Data Pages in Buffer Pool – Data Stored in Memory Cache

    Updated: 2010-06-17 02:30:38
    This will drop all the clean buffers so we will be able to start again from there. Now, run the following script and check the execution plan of the query. Have you ever wondered what types of data are there in your cache? During SQL Server Trainings, I am usually asked if there is any [...]

  • SQL SERVER – Find Largest Supported DML Operation – Question to You

    Updated: 2010-06-16 02:30:35
    SQL Server is very big and it is not possible to know everything in SQL Server but we all keep learning. Recently I was going over the best practices of transactions log and I come across following statement. The log size must be at least twice the size of largest supported DML operation (using uncompressed [...]

  • SQL SERVER – Shrinking NDF and MDF Files – Readers’ Opinion

    Updated: 2010-06-15 02:30:58
    Previously, I had written a blog post about SQL SERVER – Shrinking NDF and MDF Files – A Safe Operation. After that, I have written the following blog post that talks about the advantage and disadvantage of Shrinking and why one should not be Shrinking a file SQL SERVER – SHRINKFILE and TRUNCATE Log File [...]

  • SQLAuthority News – Author Visit – SQL Server 2008 R2 Launch

    Updated: 2010-06-14 02:30:55
    June 11, 2010 was a wonderful day because I attended the very first SQL Server 2008 R2 Launch event held by Microsoft at Mumbai. I traveled to Mumbai from my home town, Ahmedabad. The event was located at one of the best hotels in Mumbai,”The Leela”. SQL Server R2 Launch was an evening event that [...]

  • SQL SERVER – What is Denali?

    Updated: 2010-06-13 02:30:44
    I see following question quite common on Twitter or in my email box. “What is Denali?” Denali is code name of SQL Server 2011. Here is the list of the code name of other versions of SQL Server. In 1988, Microsoft released its first version of SQL Server. It was developed jointly by Microsoft and [...]

  • Display Database using TreeView and ListView with ADO.NET

    Updated: 2010-06-12 04:09:00
    using ADO.NET in Visual Studio.Net to display database in TreeView and ListView.

  • SQL SERVER – Difference Between DATETIME and DATETIME2 – WITH GETDATE

    Updated: 2010-06-12 02:30:45
    Earlier I wrote blog post SQL SERVER – Difference Between GETDATE and SYSDATETIME which inspired me to write SQL SERVER – Difference Between DATETIME and DATETIME2. Now earlier two blog post inspired me to write this blog post (and 4 emails and 3 reads from readers). I previously populated DATETIME and DATETIME2 field with SYSDATETIME, [...]

  • Showplan Operator of the Week - Lazy Spool

    Updated: 2010-06-12 01:24:24
    Continuing to illuminate the depths of SQL Server's Query Optimizer, Fabiano shines a light on the sixth major Showplan Operator on his list: the Lazy Spool. What does the Lazy Spool do that's so special, how does the Query Optimizer use it, and why is it so Lazy? Fabiano explains all...

  • On the fly Code Generation with Evolutility

    Updated: 2010-06-12 00:30:00
    A generic Web User Interface for CRUD applications generating all screens at run-time based on external metadata. It comes with sample applications for address book, memo pad, to do list, restaurants list, wine cellar, and database structure documentation that are easily customizable.

  • Book Review: Defensive Database Programming With SQL Server

    Updated: 2010-06-11 09:22:12
    It distils a great deal of practical experience; the writing of it was a considerable task; It packs in a great deal of information. Alex's book shows how to write robust database applications, and we can all learn from it. We took the book to a critic who never minces his words, and were relieved to find that Joe Celko liked it.

  • Book Review: The Art of XSD - SQL Server XML schemas

    Updated: 2010-06-11 09:22:11
    The 14 chapters of "The Art of XSD”, written by MVP Jacob Sebastian, will take the reader step-by–step all the way from the basics of XML Schema design all the way to advanced topics on SQL Server XML Schema Collections. Reviewer Hima Bindu Vejella gives it an 8/10 rating, and gives us an excellent distilled description of what the book has to offer.

  • SQL SERVER – Difference Between DATETIME and DATETIME2

    Updated: 2010-06-11 02:30:55
    Yesterday I have written a very quick blog post on SQL SERVER – Difference Between GETDATE and SYSDATETIME and I got tremendous response for the same. I suggest you read that blog post before continuing with this blog post today. I had asked people to honestly take part and share their view about the above [...]

  • SQL SERVER – Difference Between GETDATE and SYSDATETIME

    Updated: 2010-06-10 02:30:55
    Sometime something so simple skips our mind. I never knew the difference between GETDATE and SYSDATETIME. I just ran simple query as following and realized the difference. SELECT GETDATE() fn_GetDate, SYSDATETIME() fn_SysDateTime In case of GETDATE the precision is till miliseconds and in case of SYSDATETIME the precision is till nanoseconds. Now the questions is [...]

  • SQL SERVER – Fastest Way to Restore the Database

    Updated: 2010-06-09 02:30:26
    A few days ago, I received following email from blog reader: “Pinal, We are in an emergency situation. We have a large database of around 80+ GB and its backup is of 50+ GB in size. We need to restore this database ASAP and use it; however, restoring the database takes forever. Do you think [...]

  • Wizard and CRUD Applications to Build other CRUD Applications

    Updated: 2010-06-08 22:28:00
    Looking at the possibility of using CRUD applications to manage other CRUD applications inside a web browser and without any hand-coding. Also, presenting a step wizard deriving the database structure from the UI rather than the opposite.

  • Database Helper v 2.0.0

    Updated: 2010-06-08 17:53:00
    An open source code generation utility with some useful features to generate procedures,class for tables and .net code for procedures automatically.

  • SQL SERVER – Merge Operations – Insert, Update, Delete in Single Execution

    Updated: 2010-06-08 02:30:41
    This blog post is written in response to T-SQL Tuesday hosted by Jorge Segarra (aka SQLChicken). I have been very active using these Merge operations in my development. However, I have found out from my consultancy work and friends that these amazing operations are not utilized by them most of the time. Here is my [...]

  • MySql Database Backup Utility

    Updated: 2010-06-07 09:57:00
    A class to generate a complete backup of a MySql Database

  • SQL SERVER – Subquery or Join – Various Options – SQL Server Engine Knows the Best – Part 2

    Updated: 2010-06-07 02:30:05
    This blog post is part 2 of the earlier written article SQL SERVER – Subquery or Join – Various Options – SQL Server Engine knows the Best by Paulo R. Pereira. Paulo has left excellent comment to earlier article once again proving the point that SQL Server Engine is smart enough to figure out the [...]

Current Feed Items | Previous Months Items

May 2010 | Apr 2010 | Mar 2010 | Feb 2010 | Jan 2010 | Dec 2009