THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server   (RSS)
Showing page 64 of 67 (663 total posts)
  • Bulk Insert of sorted data

    In a previous post I showed how to make bulk insert faster using SSIS. During Sql Server Conference 2007 I had the great opportunity to double check it with Stefano Stefani that analyzed the problem in greater detail and finally came up with both an explanation of the problem and a simple workaround when facing the same problem with T-SQL (my ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on July 2, 2007
  • Cool DBA Automation Jobs

    I saw a demo of these at Tech-Ed, and thought I would share with my friends. Essentially, the Database Operations team at Microsoft uses a suite of jobs on all their servers for performing backups, automated database maintenance, improve performance , and improving disaster recovery. I'm sure every SQL Server ...
    Posted to Richard Hundhausen: The DBAgilist (Weblog) by Anonymous on June 18, 2007
  • Did You Know SQL Server Has A Black Box Like An Airplane?

    Paul Randal writes: ''Kimberly mentioned that SQL Server has a 'black-box' trace, similar to an aircraft flight-recorder, which I'd never heard of. It's an internal trace that has the last 5MB of various trace events and it's dumped to a file when SQL Server crashes. This can be really useful if you're troubleshooting an issue that causing SQL ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on June 3, 2007
  • Summer SQL Teaser #1 Dateformat

    Just to clarify, summer starts Memorial Day and ends Labor Day. I will post a teaser every Friday until Labor Day. Got this from my friend George, try to guess the output of the code below without running it.   SET DATEFORMAT DMY SELECT CONVERT(DATETIME, '120607')  
    Posted to Denis Gobo (Weblog) by Denis Gobo on June 1, 2007
  • Speed Up Performance And Slash Your Table Size By 90% By Using Bitwise Logic

    You have all seen websites where you can pick a bunch of categories by selection a bunch of check boxes. usually what you do is store those in a lookup table and then you create another table where you store all the categories for each customer. What if I tell you that you can store all that info in 1 row instead of 10 rows if a customer picked 10 ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on May 29, 2007
  • New, simpler AdventureWorks sample database

    Trainers and presenters have been wanting a sample database that is less complex than AdventureWorks, but more interesting than Northwind. Thanks to my friends at SolidQ for letting me know about AdventureWorksLT (Light) ... (Click to see a larger view) You can download AdventureWorksLT from CodePlex or Microsoft.
    Posted to Richard Hundhausen: The DBAgilist (Weblog) by Anonymous on April 20, 2007
  • Making Fast Load really fast on clustered indexed tables with SSIS

    I have been so used to use int identity fields as primary key for any table and to believe it’s the fastest way to define a clustered primary key that I never thought this can cause serious performance problems to SSIS. Until I tested it and discovered that int identity primary keys are among the slowest way to insert huge amount of data with ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on April 8, 2007
  • SQL Server Search Macro (plus build your own directed search!)

    Microsoft has built a little site for searching the books online on the web (which gives you links that are more readily shared with others): That is nice, but what is nicer is that you can create your own search macros and save them.. Just click the “create your own search ...
    Posted to Louis Davidson (Weblog) by drsql on April 3, 2007
  • Getting the difference between two sets of like data

    A question came up on the forums the other day that a person wanted to compare two tables of data.  Doing this is pretty easy using several techniques:   Using EXCEPT Using NOT EXISTS Using a FULL OUTER JOIN First two sample tables which represent two sets of data that you would get from a statement, from clause, etc.  ...
    Posted to Louis Davidson (Weblog) by drsql on February 8, 2007
  • SQL Server 2005 Worst Practices

    Thanks for attending my talk last night and letting me share my SQL Server 2005 Worst Practices. I hope I didn't embarass anyone too badly by highlighting your practice in my talk! Here are the slides, script, and sample project from last night's talk.
    Posted to Richard Hundhausen: The DBAgilist (Weblog) by Anonymous on January 19, 2007
« First ... < Previous 62 63 64 65 66 Next > ... Last »
Privacy Statement