RE: Anyway other faster way to do this?
Thanx rockmoose, I should have thought of this...sum first then crosstab. This works much better than my current solution.
2004-05-31
PowerShell
RE: Command line network configuration
Look into the command line switches for MSDE2000 setup. I believe DISABLENETWORKPROTOCOLS=0 will install MSDE with tcp/ip enabled. Mike
2004-05-28
RE: XML file import into a SQL table
Here is a sample, using the input as a text object. --first , create the stored procedure.if exists (select * from sysobjects where id = object_id('dbo.usp_insert_pubs_authors') and sysstat & 0xf = 4) drop procedure dbo.usp_insert_pubs_authors GO CREATE PROCEDURE usp_insert_pubs_authors ( @xml_doc TEXT )AS SET NOCOUNT ON DECLARE @hdoc INT -- handle to XML doc --Create […]
2004-05-26
2004-05-26
RE: Nested Cursors
There are probably lots of 'clever' things that you can do with cursors, but why would you bother? Learn how to code SQL properly (ie. without cursors) or switch to working with Oracle. If you need help on converting your cursors to something more elegant then post more details and I'll be happy to oblige.
2004-05-24
80 columns by 6 million rows
All,I am very new to SQL server performance tuning and I was wondering what I could do to get this table performing a bit better. I have a quad 3 GHZ box with 3GB of RAM. My table is 80 columns x 6 million records and has 1 unique clustered index. The size of the table will […]
2004-05-21
4 reads
RE: Command line Passive FTP client
We've automated a number of our FTP transmit and receipt jobs using WS_FTP Pro, and it has a a passive mode switch.http://www.ipswitch.com/MattieNH
2004-05-10
RE: Copy contents of one table from one server to another
If I understand your question correctly (obtain 50 rows via email), have your 'partner' export the 50 rows to a comma or tab delimited text file, zip it and then send it to you. When you receive it, unzip and bcp in or bulk insert into your table. Sounds so easy, I'm almost sure I'm […]
2004-05-10
RE: Pros and cons of doing replication and log shipping together
i didn't phrase the question properly. Let me put this way. I want log shipping and replication both from primary production database. One for standby(DR) and one for replication(read only db) Primary Database(proddb) ==log shipping == standby db(prodstdby) Primary Database(proddb) ==replication == read only (prodread) what are the pros and cons of this kind of […]
2004-05-01
RE: logins after db restoration
I sometimes use the following, provided the users are already a part of the Security\login:(change the LoginName to the user who needs to be changed)EXECUTE sp_change_users_login 'Auto_Fix', 'LoginName'
2004-04-29
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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