Detecting Differences in Files on Servers
Detecting file differences on two different web servers using T-SQL.
2015-07-30
5,573 reads
Bulk import
Importing and exporting bulk data with the bcp utility
The SQL Server bcp utility can help administrators easily import or export bulk data between text files and SQL Server tables.
2009-03-04
4,119 reads
The Data Loading Performance Guide
This document described techniques for bulk loading large data sets into SQL Server. It covers both the available techniques as well as methodologies to performance tune and optimize the bulk loading process.
2009-02-24
3,931 reads
Using OPENROWSET to read large files into SQL Server
OPENROWSET is a T-SQL function that allows for reading data from many sources including using the SQL Server’s BULK import capability.
2008-12-29
6,687 reads
XML Import Solution
This article explores how we can import XML into SQL Server using a powerful open source tool called XMLStarlet
2008-10-09
10,527 reads
AVG in cube
Hi all, I'm trying Analysis Services to possibly deploy some projects over it.I'm doing my first cube, so, I'm totally newbie and I have only access to 2k Standard Edition 🙁My first problem is: I need AVG function, and only have SUM, COUNT, MAX, MIN & DISTINCT COUNT.Exists an AVG function here?Is only avaliable in Enterprise […]
2004-07-22
3 reads
RE: Using variables within IN
John - i'm used to using derived tables in my selects - bad habit i've picked up 🙂 thanks for reminding me
2003-06-16
2 reads
RE: Comparing two tables
I have tested the sp from another databse too. It worked fine. Please Check your T-SQL statement. (Is the database name correct? Is the Schema name DB in the first database?)
2003-06-12
1 reads
RE: Monitoring Performance
Allan, spTraceBuild must be totally re-written to work in sql7, not just the line with the function fn_trace_getinfo (which BTW can be simply taken off). If you ever run traces programmatically in sql7 you know that it's doable. It's only an issue of spending time. Since the traces have been collected they can be processed […]
2003-06-11
RE: Server slow down after stopping replication
landy, send me a email.. i lost your email address and i think i have found some information that will help in your issue.. kim
2003-06-09
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers