News in the Category:
SQL 
Total posts: 3906 | Sort by Views | Sort by Hits
Julia Lerman Blog - Dont Be Iffy..., March 11, 2010
Views: 58 | Hits
Perhaps the title of this blog post will suffice, but I just wanted to highlight this problem. If you were to look up the timestamp data type in the SQL Server 2008 documentation, this is waht you wi...
Journey to SQL Authority with Pinal Dave, March 11, 2010
Views: 78 | Hits 2
Recently I received the following two questions from readers and both the questions have very similar answers.Question 1: I have a unique requirement where I do not want to use any index of the table;...
Run Tings Proper, March 11, 2010
Views: 78 | Hits 2
This is a simple looking error message that is deceptively hard to track down. Thankfully if you're having this problem then this article should get you back on track without spending hours scratching...
Steven Smith, March 10, 2010
Views: 88 | Hits
Still working on getting a TeamCity build working (see my last post). Latest exception is: C:\Program Files\MSBuild\Microsoft\VisualStudio\v9.0\TeamData\Microsoft.Data.Schema.SqlTasks.target...
Steven Smith, March 10, 2010
Views: 75 | Hits
Setting up a TeamCity build and got this error: C:\Program Files\MSBuild\Microsoft\VisualStudio\v9.0\TeamData\Microsoft.Data.Schema.SqlTasks.targets(80, 5): error MSB4018: The "SqlSetupDeploy...
Journey to SQL Authority with Pinal Dave, March 10, 2010
Views: 93 | Hits 5
Professional SQL Server 2008 Internals and Troubleshooting by Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Steven WortLink to Amazon (Worldwide)Link to Flipkart (India)Brief Rev...
MSDN: ASP.NET, March 9, 2010
Views: 122 | Hits 8
Join your local MSDN Events team as we take a deep dive into Microsoft Windows Azure. We'll start with a developer-focused overview of this brave new platform and the cloud computing services that can...
Journey to SQL Authority with Pinal Dave, March 9, 2010
Views: 125 | Hits 18
This blog post is in the response of the T-SQL Tuesday #004: IO by Mike Walsh. The subject of this month is IO. Here is my quick blog post on how Cover Index can Improve Performance by Reducing IO.Let...
The Code Project Latest Articles, March 8, 2010
Views: 99 | Hits 16
A tool that facilitates the truncation of SQL log file...
Journey to SQL Authority with Pinal Dave, March 8, 2010
Views: 97 | Hits 4
I was recently asked question about SQL Server 2008 pricing. I have bookmarked official site here which lists the pricing.Official site: What’s New in SQL Server 2008 R2 EditionsEditionsPer Processor ...
The Code Project Latest Articles, March 6, 2010
Views: 165 | Hits 53
Article provides example solution for presenting data in "real-time" from Microsoft SQL Server in HTML browser. Article presents how to implement Comet functionality in ASP.NET and how to connect Co...
Journey to SQL Authority with Pinal Dave, March 6, 2010
Views: 143 | Hits 2
SQL Server Modeling (formerly code name “Oslo”) is a set of future technologies that provide significant productivity gains across the lifecycle of .NET applications by enabling developers, architects...
Marquee de Sells: Chriss insight outlet, March 5, 2010
Views: 125 | Hits 2
Here's how the Deep Fried guys describe episode 45: "At PDC 2009, 'Oslo' was renamed to SQL Modeling and it left a lot of developers scratching their heads. What better way to sort it all out than to...
Journey to SQL Authority with Pinal Dave, March 5, 2010
Views: 101 | Hits 15
I recently received few comments that I have not written on simple subjects recently. In fact, this blog is dedicated to all those who are really learning SQL Server and almost all the articles and po...
Marquee de Sells: Chriss insight outlet, March 4, 2010
Views: 104 | Hits 10
An update of the SQL Server Modeling CTP (November 2009) that's compatible with Visual Studio 2010 RC has been released on the Microsoft Download Center. This release is strictly an updated version of...
Marquee de Sells: Chriss insight outlet, March 4, 2010
Views: 82 | Hits 5
An update of the SQL Server Modeling CTP (November 2009) that's compatible with Visual Studio 2010 RC has been released on the Microsoft Download Center. This release is strictly an updated version of...
the telerik blogs, March 4, 2010
Views: 103 | Hits 9
Q1 2010 will be a milestone release for our enterprise-grade ORM. With it we will introduce the new Visual Designer for OpenAccess ORM. The designer will give developers the ability to map their datab...
Journey to SQL Authority with Pinal Dave, March 4, 2010
Views: 121 | Hits 15
This is very common concept that truncate can not be rolled back. I always hear conversation between developer if truncate can be rolled back or not.If you use TRANSACTIONS in your code, TRUNCATE can ...
Al Pascual, March 3, 2010
Views: 111 | Hits 6
tweetmeme_url = 'http://alpascual.com/blog/the-new-microsoft-sql-server-compact-edition-3-5-in-visual-studio-2010-rc-without-geometry-types/';tweetmeme_source = 'alpascual';With the goodies coming wit...
Journey to SQL Authority with Pinal Dave, March 3, 2010
Views: 120 | Hits 20
Recently I wrote aboutSQL SERVER INSERT TOP (N) INTO Table Using Top with INSERT I mentioned about how TOP works with INSERT. I have mentioned that I will write about the performance in next article...
Simple Talk, March 2, 2010
Views: 4 | Hits
In the second part of Phil's series of articles on finding stuff (such as objects, scripts, entities, metadata) in SQL Server, he offers some scripts that should be handy for the developer faced with ...
Guy Barrettes WebLog, March 2, 2010
Views: 93 | Hits 3
In SQL Azure, when you create a server, a master database is automatically created and youll see it listed in the databases list. Heres a screenshot after I created a new database called Test. ...
Journey to SQL Authority with Pinal Dave, March 2, 2010
Views: 101 | Hits
TechEd Sri Lanka was held at Waters Edge, Colombo between Feb 8 and Feb 10, 2010. It was one of the largest successful technical event in Sri Lanka. I was extremely surprised to how technically sound ...
Journey to SQL Authority with Pinal Dave, March 1, 2010
Views: 112 | Hits 7
The performance of SQL Server is primarily decided by the disk I/O efficiency. Improving I/O definitely improves the performance. SQL Server 2008 introduced Data and Backup compression features to imp...
Journey to SQL Authority with Pinal Dave, February 28, 2010
Views: 101 | Hits 2
I recently presented in Hyderabad User Group on the subject of The Other Side of SQL Server Index: Advanced Solutions to Ancient Problem , you can read more about this event here SQLAuthority News MU...
More Whidbey stuff, February 27, 2010
Views: 105 | Hits 6
Continuous integration enables developers to have an automated way of validating the quality of their check-ins. A CI server will monitor your version control repository and on every check-in will bu...
Journey to SQL Authority with Pinal Dave, February 27, 2010
Views: 122 | Hits 11
During my recent training at one of the clients, I was asked regarding the enhancement in TOP clause. When I demonstrated my script regarding how TOP works along with INSERT, one of the attendees sugg...
Steven Smith, February 26, 2010
Views: 115 | Hits 1
I just ran into a problem with SQLite and NHibernate, which was giving me this error message: The IDbCommand and IDbConnection implementation in the assembly System.Data.SQLite could not be found....
Julia Lerman Blog - Dont Be Iffy..., February 26, 2010
Views: 95 | Hits 1
Join the team at Gardener's Supply Company! We work hard AND offer a fun place to work with summer bocce games, BBQs, ping-pong tournaments, employee garden plots and much more! We also offer strong c...
Journey to SQL Authority with Pinal Dave, February 26, 2010
Views: 123 | Hits 1
Last year during my visit to SQLAuthority News SQL PASS Summit, Seattle 2009 Day 2 I have received ducks from the event. Well during the same event I had learned from Jonathan Kehayias the saying of...
WebLog of Ken Cox [MVP], February 25, 2010
Views: 230 | Hits 51
Since the launch of Windows Azure, Ive been using my complimentary Microsoft MVP MSDN Premium subscription to play with Azure and enter some deployment contests. Unfortunately, I left up those trivial...
Guy Barrettes WebLog, February 25, 2010
Views: 99 | Hits 5
If you played with Azure CTP and left some VM running, know that they were transferred to a paid account starting Feb 1st and you are currently being billed for usage time. Yesterday, during an ...
Journey to SQL Authority with Pinal Dave, February 25, 2010
Views: 103 | Hits 2
Earlier this month, I was very fortunate to visit Microsoft User Group Hyderabad lead by Hima Vindu Vejella. Hima is a very enthusiastic leader and kind person. I had a wonderful time meeting her as w...
Steven Smith, February 24, 2010
Views: 233 | Hits 45
Occasionally I find myself wanting to SELECT from a SPROC in SQL Server. Usually this is because I want to ORDER the results or filter them further with a WHERE clause. Unfortunately, you ...
Fervent Coder, February 24, 2010
Views: 140 | Hits 26
One thing most database change management tools use is SQL Server Managment Objects (SMO). Most do that because ADO.NET doesnt allow the batch statement separator keyword GO in sql statements. So most...
Journey to SQL Authority with Pinal Dave, February 24, 2010
Views: 140 | Hits 33
In this article we will go over basic understanding of Rollup clause in SQL Server. ROLLUP clause is used to do aggregate operation on multiple levels in hierarchy. Let us understand how it works by u...
Marquee de Sells: Chriss insight outlet, February 23, 2010
Views: 119 | Hits 8
We are currently preparing a release of the SQL Server Modeling November 2009 CTP that will install and operate with Visual Studio Release Candidate. We expect to make this release available the first...
Journey to SQL Authority with Pinal Dave, February 23, 2010
Views: 143 | Hits 4
I have quite often received request for the Data Mining Algorithms details. Book Online has wonderful resources for the same. I suggest to read them here.Data Mining Algorithms (Analysis Services – Da...
The Code Project Latest Articles, February 22, 2010
Views: 147 | Hits 30
The lightbox control reads data from your backend SQL Server....
Journey to SQL Authority with Pinal Dave, February 22, 2010
Views: 126 | Hits 4
Quite often I get email where many readers ask me how to get email from SQLAuthority.com blog. Today very quickly I will go over few standard practices of this blog using you can stay connected with S...
Al Pascual, February 21, 2010
Views: 144 | Hits 30
tweetmeme_url = 'http://alpascual.com/blog/the-orchard-project-as-my-new-blog-engine/';tweetmeme_source = 'alpascual';Orchard is an open source CMS web application that will allow you to create any we...
Journey to SQL Authority with Pinal Dave, February 21, 2010
Views: 155 | Hits 24
Few days ago I wrote article about SQL SERVER Stored Procedure Optimization Tips Best Practices. I received lots of comments on particular blog article. In fact, almost all the comments are very int...
Journey to SQL Authority with Pinal Dave, February 20, 2010
Views: 162 | Hits 25
I recently received email from reader after reading my previous article about SQL SERVER Plan Recompilation and Reduce Recompilation PerformanceTuning that how to recompile any stored procedure at r...
Journey to SQL Authority with Pinal Dave, February 19, 2010
Views: 123 | Hits 4
Microsoft SQL Server Migration Assistant (SSMA) 2008 is a toolkit that dramatically cuts the effort, cost, and risk of migrating from MySQL to SQL Server 2008 and SQL Azure. SSMA 2008 for MySQL v1.0 C...
Simple Talk, February 18, 2010
Views: 88 | Hits 3
The Quirky UPDATE technique has been available to programmers throughout the time Sybase and SQL Server has existed, and so cannot be lightly cast aside, even if one sympathises with Microsoft for the...
Journey to SQL Authority with Pinal Dave, February 18, 2010
Views: 147 | Hits 8
Recompilation process is same as compilation and degrades server performance. In SQL Server 2000 and earlier versions, this was a serious issue but in SQL server 2005, the severity of this issue has b...
Microsoft Certified Professional Magazine Online | Todays Top Picks, February 17, 2010
Views: 201 | Hits 50
Microsoft on Friday announced when it will release new service packs for two of its SQL Server products....
Journey to SQL Authority with Pinal Dave, February 17, 2010
Views: 168 | Hits 17
The white paper describes load strategies for achieving high-speed data modifications of a Microsoft SQL Server database.“Bulk Load Methods and Other Minimally Logged and Metadata Operations provide a...
Journey to SQL Authority with Pinal Dave, February 16, 2010
Views: 428 | Hits 77
We will go over how to optimize Stored Procedure with making simple changes in the code. Please note there are many more other tips, which we will cover in future articles. Include SET NOCOUNT ON stat...
Patrik Löwendahls shout, February 15, 2010
Views: 51 | Hits 10
In my current project one of the actions Ive taken is to have the project and team move away from Linq To Sql to NHibernate. There was a multitude of issues that was the basis for this move, some of t...