Transferring Table Types
An interesting idea. I saw this question asked after I was playing with table types a bit. “Can you move...
2012-09-25
1,685 reads
Blog Posts
Using a TVP instead of Dynamic SQL to pass a list into a SP
A couple of days ago I read Steve Jones’ blog on creating a user defined table type. This reminded me...
2012-09-25
1,185 reads
@LearningTree: Unlimited Passport
Its not often I publish two blog posts in a single day but this Monday I will make an exception....
2012-09-24
974 reads
Last Call To Register for SQLSaturday Orlando
This coming Saturday (September 29th) we’ll be having our sixth annualSQLSaturday at Seminole State College (our site partner since the...
2012-09-24
653 reads
Max Text Replication Size – When you might have to care about this number !
One of the advanced Server level options for SQL Server is Max Text Replication Size and this is really not a common...
2012-09-24 (first published: 2012-09-18)
6,897 reads
SQL Server Virtualization and Consolidation
December this year will be a great month for me. I am scheduled to deliver my new Learning Tree course...
2012-09-24
693 reads
SQL Server: Part 3 : Approaching Database Server Performance Issue
In the last post, we have discussed the script to list the sessions which are waiting for resource or currently...
2012-09-24
1,165 reads
TechEd Australia 2012 videos online
Microsoft has posted ALL the session videos for TechEd Austrialia 2012 and they are available for free! Get your learning...
2012-09-24
802 reads
The Reason I Won't Be at the PASS Summit This Year
We welcomed daughter #3 and child #5 into this world on Saturday at 9:43 AM. She came a bit earlier...
2012-09-24
1,487 reads
Congrats to Jeff Walker for passing the VMware VCP5 exam
Jeff Walker (blog), a great coworker of mine at House of Brick Technologies, passed the VMware Certified Professional for vSphere...
2012-09-23
641 reads
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers