Summarizing Imported Data
This article shows a few simple techniques to summarize table data using T-SQL.
2012-07-27
2,013 reads
import
JSON.SQL: A CLR-resident JSON serializer/deserializer for SQL Server
One CLR function and four CLR procedures for the import/export of JSON data to and from SQL Server are presented, with supporting performance metrics.
2011-07-18
15,595 reads
Export/import relational data across SQL Servers
The XportXML utility, will help you copy relational data (a bunch of related tables) to another SQL Server keeping the relational integrity intact, even when new primary keys are generated.
2009-07-08 (first published: 2009-06-22)
1,539 reads
RE: CASE in computed column
Ah - I do have an index on it. It's a name though - not very like to chnage much.
2005-05-06
RE: Super Sunday
I'm not too sure of the rules of American football however if you are prepared for a little foreign intervention try Rugby. If Rugby looks too sissy try Australian football. The Aussies don't like to waste drinking time so they seem to have integrated the best aspects of rugby and the post match punch-up into […]
2005-02-13
RE: tools to document a database?
Erwin and Visio can reverse-engineer tables/views. SQL itself can provide the code for all objects and you can look at sysdepends/syscomments for additional information (may not always be 100% accurate though)
2005-02-03
RE: Trapping Connection Errors
It is not a problem with insert itself. If you run my script without dmo part insert works fine. Also from my experience, if I want to insert from linked server to temporary table, only global table will work. In my case it has to be something specific to dmo connection. Below is my script where […]
2005-01-21
1 reads
RE: I need help!
So, in cases where the gap is > 30 days, it is required to have certain records in the final temp table *twice* ?
2005-01-21
RE: Total beginner can''''t even connect with OSQL
RUN: C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SVRNETCN.exeThis is the SQL Server Network Utility. Enable Name Pipes and TCP/IP. Then try running OSQL -E at a command line.However, please note that your workstation's SQL instance will be visible to others. Therefore, domain administrators would be able connect to your SQL Server.Let me know if this works.Ryan
2005-01-21
1 reads
2004-11-18
Blogs
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
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