Jason Edward Rowland (1/12/2010)

---

There is another advantage to using this as opposed to SQL Agent. You can regulate the number of packages that execute concurrently by setting the max_queue_readers value.

The...

For sure this is a nice way of launching a package when you have no SQLAgent in your system ( express edtn )

But if you have SQLAgent in your instance,...

IMO for most of us, getting their first x64 is the upmost occasion to "finally" get a bigger server.

In many cases having 2 or 4 poc ( nowadays 4 to...

You have a circular reference !!!!

Table2 has a FK to Table3

AND

Table3 has a FK to Table2

- What's the point ??

- are the FK columns Nullable ?

Avoid circular references !

/* 1- create database d1;*/

create database d1;

/* 5- create new login login1. */

CREATE LOGIN [Login1] WITH PASSWORD=N'Login&', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF

GO

/* 2- create new user u1 */

USE [d1]

CREATE USER [u1] FOR...

Budi Hertanto (1/8/2010)

---

Hi,

I still got error using FOR LOGON TRIGGER, even I'd already using SQL SERVER 2005 SP3. Do I need configure something else?

The value of @@VERSION show:

Microsoft SQL Server...

IMO, sampling the proc cache on a daily basis is a way to long interval.

It is indeed a good way with minimal impact and no modification of existing stuff.

FWIW I...

Don't shoot me if it doesn't perform as expected.

You could add a persisted derived column and partition on the combination of the flagprocessed and the stringconverted datetime combined..

Keep min mind...

another nifty thing we've been provided with :

declare @TestD varchar(12);

set @TestD = '1e1'

declare @testINT integer

begin try

set @testINT = convert(float,@TestD)

Print '[' +...

the query will provide the same results. partitioned or not.

If you are refering to the sliding window technique, off course, you should first check it the partition only contains data...

is your app user connected to the correct database ???

(Always specify your wanted database at connect time, don't rely o "default database" behaviour)

double check your client software has SP4 applied (or the software level of your connected SQL2000 instance).

GSquared (1/7/2010)

---

Servers usually aren't all that loud, but the limit would really...

Gail published a very explanatory article at SSC:

http://www.sqlservercentral.com/articles/64582/

Or by activating a login trigger (needs sp2) which only alows 'sa' or members of sysadmins sqlgroup.

Could be usefull if you intend to acivate it for a maintenance window, but...