Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

20 March 2013

Dynamics GP Land: Updating Records with Excel

Christina Phillips shows off an option for Updating Records with Excel. It's a hack...and I use it a lot.

By a hack I mean that if you show this off to SQL professionals they will laugh at you...and it won't matter because your work will be done and you'll be going home.

06 August 2012

Weekly Dynamic: Line Numbers in SQL Server

Many of you know just enough SQL to get by. By definition that involves some trial and error to get things right. Inevitably one of your Select statements will fail and SQL will give you some hints about what's wrong including a line number.

But how do figure out what line is what? Do line numbers include spaces? There is a line number listed in the bottom right but even that is a pain to use.

In SQL Server Management Studio you can turn on line numbers with Tools | Options, expand Text Editor, Expand Transact-SQL, select General and check Line Numbers under Display.

03 May 2012

RAID and Its impact on your SQL performance - SQLServerCentral

For most of you, SQL Server Central's new article, RAID and Its impact on your SQL performance will be more than you ever wanted to know about a redunant array of independent disks (yes, I know that the "I" in RAID is somewhat disputed. Independent, Inexpense, InanotherlifetimeIwillcare.)
If this isn't geeky enough for you, make sure to check out the comment at http://www.sqlservercentral.com/Forums/Topic1292935-143-1.aspx

This table summarizes the pros and cons of each of the Standard RAID Levels

RAID Level Fault Tolerance Read Performance Write Performance RAID Write Penalty Cost
0 None Good Excellent 1 Excellent
1 Good Good Good 2 Fair
5 Fair Good Poor 4 Good
1+0 Excellent Excellent Excellent 2 Poor
DP Good Good Terrible 6 Good

SQL Error: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32) - Developing for Dynamics GP - Site Home - MSDN Blogs

David Musgrave solved an interesting case with a SQL Error: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)

09 April 2012

Free ebook: Introducing Microsoft SQL Server 2012 - Microsoft Press

For those of you looking for information about SQL Server 2012, Microsoft has a Free ebook: Introducing Microsoft SQL Server 2012. This is 288 pages of new stuff.

I’m impressed that MS is offering this in Mobi (Kindle), epub(other ereaders) and PDF formats. They recognized the growth of eBooks and responded.

28 March 2012

Dynamics GP 2010 R2 Database SDK | Interesting Findings & Knowledge Sharing

Sivakumar couldn’t make it to Convergence this year so he stayed home and pouted…or rather built a very cool Dynamics GP 2010 R2 Database SDK documenting GP objects in an easy to use manner.