Create MERGE statements with data!
A script to create MERGE statements with data for specific tables.
2015-09-03 (first published: 2014-05-19)
5,054 reads
SQL Server Data Tools (SSDT)
Dynamically Download FTP Files Using SSDT
Dynamically initialise FTP connection using expressions and retrieve files stored in multiple FTP directories using SQL Server Data Tools
2013-03-11
8,355 reads
RE: how to index partitioning views and create triggers on them
i have created a partitioned view as create view aasselect * from tbl1union allselect * from tbl2 and tbl1 and tbl2 have the same structure and primary keys are defined on them and we have a chek constraint on one of the column which is the part of the primary key.after creating the instead of insert,delete and […]
2005-02-16
RE: SQL Server 2005 Minimum hardware requirements
There are some requirements but I have it running on a p11 450 with 512 mb ram and although it complains it works well enough for eval. I seem to remember P111 800 + 1 Gb ram.
2005-02-03
1 reads
RE: Results from 1 column of many records into comma list
haha, my method is clearly described in the earlier post. Sorry.
2005-01-21
RE: Which version of SQL Server do I need?
Hi - MSDE is creaking (imo) because in the event logs I see the 'exceeded 8 concurrent connections' too many times. The site is not busy yet either! What I was trying to find out is if my interpretation of the event logs, is resulting in a visible effect on performance for visitors to the […]
2004-12-03
copying roles and user to another server
HIIs there a way to copy users and roles from one server to another, something like the generate script option for SP?I have an access control configure on my p.c but now i have to transfer it to my client server and I dont want to built it all over. thanks
2004-10-31
3 reads
Pivot Table error retreiving data from Cube
We have a dimension in a cube with 7 levels and levels are visible.In both Analysis Manager and MS Office Excel Add-in for SQL Server Analysis Services, were are able to see the last level. However, using Pivot Tables we are not and in the measures the Pivot Table will return N/A.
2004-10-21
RE: Microsoft SQL Server Health and History Tool Version 2
http://www.microsoft.com/downloads/details.aspx?FamilyID=eedd10d6-75f7-4763-86de-d2347b8b5f89&displaylang=en
2004-09-20
RE: Keyword LineNo
I've found what I was looking for. The function is called ROW_NUMBER(). Here's an example of its usage:select row_number() over (order by name) as row_num , name from sys.all_objects order by name Still don't know what LineNo is supposed to be for though!!!
2004-09-02
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