The SQL Delete Statement
New Author! Narayana has some ideas on the delete statement and how you can have a fall back plan if something goes wrong.
2003-07-22
19,487 reads
Articles
Replacing BCP with SQLBulkLoad
New Author! Stephan writes about why he thinks the bulk load capabilities added in the SQLXML3 addition are a great way to handle imports - maybe so good that you'll stop using BCP.
2003-07-21
12,287 reads
Review: EditPlus
Everyone uses a text editor. Whether for programming, editing configuration files, or reviewing logs. Here's a look at an inexpensive replacement for notepad that performs a number of functions that DBAs might be interested in having.
2003-07-18
7,935 reads
Freeware : DDL Source Safe Archive Utility
If your shop is even close to the typical Microsoft SQL Server environment there are several people that can make changes to the production environment and what's in SourceSafe does not match what's on the SQL Server. This freeware by Bill Wunder will make archiving DDL and DTS packages a piece of cake and simplify deployment of SQL Server code. Available exclusivily for SQLServerCentral.com members.
2003-07-17
802 reads
MSMQ Extended Stored Procedures For SQL Server
As you might guess from the title, this is an extended stored procedure that you can use to interact with MSMQ. It's supposed to be extremely fast, able to handle 4-5k messages per second and have a very small memory footprint. (Press Release)
2003-07-17
1,310 reads
Example VSS Framework - Source Code Management - Part 2
In part two of this article Chris explains how to handle some common issues you'll run into while using version control and how to manage the process. Defintely read part one first if you haven't already.
2003-07-16
4,760 reads
Building Business Intelligence Data Warehouses
New author! Tom publishes his first article with us by writing about how business intelligence and data warehouses work together at a high level. Interesting stuff.
2003-07-15
9,144 reads
New Product - Equivalent Script
At Last! No need to convert SQL Scripts from one dialect to another. Although SQL is a simple language, it can be tedious, inaccurate and frustrating when developing equivalent SQL scripts for multiple database servers. This product handles the conversion for you. (Not Reviewed)
2003-07-15
804 reads
The Best of SQLServerCentral.com 2002 - Follow Up
Hopefully you've heard by now that we're publishing a book consisting of our best content from 2002. Sign up for the book is going well, but we could still use a few more. This update answers some of the questions we've received so far.
2003-07-14
4,198 reads
UDF as Computed Column Part 2
Dinesh is back with another article on user defined functions, giving some more great examples. If you haven't read the first one, definitely go back and read it first.
2003-07-14
7,053 reads
Blogs
How to get data in a DataFrame via .NET for Apache Spark
By Ed Elliott
When I first started working with Apache Spark, one of the things I struggled...
The End of PASS
By Andy Warren
I think our profession was the better for having a professional association, even if...
Platforms for Events
By Andy Warren
in my last post I wrote about thinking of the tools as being a...
Forums
Nested loop/HashJoin and left/right/full join
1. What is the difference among nested loop?hash join and merge join? 2. what...
SSMS & Excel - Copy Paste - DateTime Columns
Dear Group: I am not sure if this is a T-SQL / SSMS issue,...
Linked Server Insert error
Hello i have linked server one server in cloud one is local from local...
Ask SSC