Hadoop

Technical Article

RE: Query Analyzer and sysdepends

  • Reply

HELLO BRIAN,Not sure if this is the best way to add on a question to this topic, but could not find alternative...  I just loaded a script with about 20 stored procedures.  they were in alpha order rather than ordered by called procedures prior to the calling procedures.  should I worry that I got this […]

You rated this post out of 5. Change rating

2005-02-21

Technical Article

Workflow question

  • Topic

In my DTS package I have two connections: GA2_remote, GA2_local Let's say I have a Data Pump.Then on successful completion of this data transfer I want to do another Data Pump with the same GA2_remote and GA2_local connections.Can I do that? If yes how do I control the workflow? How do I say SQL Server […]

You rated this post out of 5. Change rating

2004-10-12

Technical Article

RE: Setting Up SQL Mail

  • Reply

Thanks for your reply... the default mail client is set to be Outlook 2000 and not express.Second, how do I modify the Sql Agent Mail properties?  If I go into the services and open up the properities for the SqlAgent it doesn't give me anything... I am still confused because when I try to set […]

You rated this post out of 5. Change rating

2004-10-07

Technical Article

RE: Bckup, Append or overwrite?

  • Reply

I can answer a couple.  Tempdb shrink should not be too much of a problem assuming that you have fast disks.  Use statistics io to monitor.For moving your db, try detaching and attaching your database instead of restoring.  This should be a reasonable way to handle this. as far as backups, I do not do appends, […]

You rated this post out of 5. Change rating

2004-09-22

Technical Article

RE: High usage of memory

  • Reply

That is the nature of SQL Server, It allocates as much as it needs.You can limit max memory SQL Server can use by configuring the min and max memory from either EM or sp_configure command.Use performance monitor to watch how SQL Server consumes memory and other system resources. 

You rated this post out of 5. Change rating

2004-08-20

Technical Article

RE: Authenticaiton over internet - Windows or SQL?

  • Reply

The web site, it'll be on the Internet? Generally, unless you're using something like ISA server, it's not a good idea to allow your web server to be a member of a domain. Therefore, you don't have the option of Windows authentication unless you create a local Windows account on the SQL Server that matches […]

You rated this post out of 5. Change rating

2004-08-18

Blogs

Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox

By

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

Note: I DO NOT recommend this. Any changes to a pipeline should be in...

A New Word: Symptomania

By

symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers