lee posted on February 21, 2012 20:03
I was deleting some data in production the other day, and because of the existing indexes and data types, I was a bit constrained on how to remove the rows.  Using some of the things that I’ve previously mentioned in other “Deleting Data” blogs, I added something today that I thought was pretty... [More]

Posted in: SQL Server 2008/R2 , TSQL  Tags:
Tom Davis, Managing Consultant at Sogeti USA contributes the following blog entry for today. Entity Framework (EF) doesn’t play well with table-valued parameters. Remember that these are an excellent way to call a process once, rather than over and over, to send data to SQL Server. While some lo... [More]

Posted in: .Net , SQL Server 2008/R2  Tags:
SQL Server Sizing, HA and Performance hints has a blog out on the –T 1117 trace flag that I happened upon; there has been a lot of info about this trace flag, but I never really paid much attention to it outside of the context of tempdb. This blog reminds that the flag, when set, can affect file gro... [More]

lee posted on February 17, 2012 14:29
One thing I’ve noticed recently, over the last year or so, is the increasing problem in our large SQL Server community of writers not citing their sources of information as they should be doing.  I include folks over at SQLBlog.com, SQLServerPedia, personal blogs, SQLServerCentral.com, SQL Serv... [More]

Posted in: Etc. (Off-topic)  Tags:
I always like going to the new product launches…SQL Server 2000 was a big one, as well as SQL Server 2005. The latter was a the Dallas Convention Center if I remember correctly, and had a huge turnout. Always enjoy getting the goodies (pens, paper, hats, etc.) and meeting up with old friends. The li... [More]

Posted in: SQL Server 2012  Tags:
Another good tip for beginners -  remember that if you make a simple change in SQL Server Management Studio (SSMS) by opening up the table in design mode, you might see your entire IDE hang; the reason is because SQL Server could be doing a complete DML operation in the background, moving all o... [More]

Posted in: Beginner  Tags:
The Portuguese PFE SQL Server Team, no less, has posted a link to an updated KB entitled “How to choose antivirus software to run on computers that are running SQL Server. Check out the links for further info – here are the highlights that I took away: Exclude directories with .mdf, .ldf, and .n... [More]

Posted in: Vids , The Best of MSDN Blogs  Tags:
I’ve done a few blogs on SQL Server CE (Compact Edition) because I think it’s cool. I do not believe that it’s an enterprise-class relational database, but sometimes you may not need SQL Server Enterprise Edition to handle a given task. It’s free, and it doesn’t require a large or lengthy install. T... [More]

Posted in: Etc. (Off-topic)  Tags:
You might get the following error when trying to connect to a SQL Server CE edition on a network share SQL Server Compact does not support opening database files on a network share. (System.Windows.Forms).     So much for me trying to put my SQL Server CE database on my cluster h... [More]

I have a couple of blogs extoling the greatness of the latest virtual labs that Microsoft has created for you and me…it might help some folks to actually review some of the features of SQL Server 2012 first before going and doing a lab. This eBook has some information that may help introduce the new... [More]

Posted in: The Best of MSDN Blogs  Tags:
In the other post I showed one way to insert data into SQL Server CE; here I’m going to extract data from it using only the SSIS delivered tasks. Why you ask? If you’ve consulted as I have for several years, you know that in some shops, notably BI shops, that the true hardcore BI folks do not do cus... [More]

Posted in: SSIS  Tags:
  Someone here at work is going to use SQL Server Compact Edition (SQL CE) to do some data storage, so I wanted to check it out as well since I haven’t used that version before. Google shows some folks having problems connecting to it and pushing/fetching data via SSIS, some links below ... [More]

Posted in: SSIS  Tags:
Here’s a cool tip/reminder from a blog that I saw the other day – the startup parameters for SQL Server now has its own tab. Before you had to scroll to the end of the startup parameters and add a semicolon to the configuration, which was a pain. You never really could see all of them at once, and e... [More]

Posted in: The Best of MSDN Blogs  Tags:
  Someone asked me the other day what blogs I follow. I guess I don’t follow too many, but if I had to recommend some, Aaron Bertrand has a really good blog and covers some good stuff. Tim Mitchell is a good friend and someone I consider a cool dude, and Jamie Thomson always posts some g... [More]

Posted in: Beginner , TSQL  Tags:
You might get the following whilst trying to attach a .sdf file (SQL Server Compact) in SQL Server Management Studio: Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) Additional Information: An exception occurred while executing a Transact-SQL statement or batch.... [More]

Posted in: SQL Administration  Tags:
An idea came over me last night…back over two years ago I wrote a few blogs on table variables, and was using one the other day. I remembered that they have a problem in some instances with transactions, and could possibly not be ‘rolled back’. It states in Books Online that the duration is short, b... [More]

Posted in: TSQL  Tags:
lee posted on January 25, 2012 16:46
I’m seeing more and more information on SQL Server 2012 coming, including the Virtual Launch Event which is on March 7, 2012. Check out this MSDN post for the latest stuff. And, if you haven’t downloaded it yet, I suggest that you go grab it and start dorking with it. It’s pretty nice! I suggest as ... [More]

Posted in: SQL Server 2012  Tags:

by Lee Everest, M.S.

Poll

Do you use Azure or cloud in your organization?
Show Results

Ads

Search


Month List

Calendar

«  February 2012  »
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
2728291234
567891011
View posts in large calendar

Tags

Disclaimer
The opinions, code, examples, et.al. expressed herein are my own personal opinions and do not represent my employer's view in any way, shape form, or fashion.  All code for demonstration purposes - no guarantees, either written or implied, are made.

© Copyright 2012 Lee Everest's SQL Server, etc. weblog