mdkmohan (4/8/2012)

---

Hi,

I just need to disable sql jobs during holidays.

I found few ways for doing that but I don't know which is more efficient and generalized method.

Kindly provide your suggestion...

gwphillipson (4/6/2012)

---

Hi PaulB

Is that Replication Management Objects Concepts?

http://msdn.microsoft.com/en-us/library/ms146869.aspx

Also would it be possible to install sql 2005 onto my VPS server from my desktop, if so how would i go about...

When using four-part naming query uses to transfer whole tables over the network from remote to local server, then apply filtering in local server - that's why it takes much...

Sourav-657741 (4/6/2012)

---

If I am wrong I believe partitioning the table helps in improving the performance because we are placing the ranges of the data in individual File groups....so instead of...

Sourav-657741 (4/6/2012)

---

The table has more than 35 million+ records and of which while trying to extract the results against the particular columns (the columns holds values as : 0,1 and...

Threshold for lock escalation is 5,000 locks acquired for the same referenced table, table partition or index. Each time SQL Server engine finds that 5,000 locks have been acquired...

sivag (4/6/2012)

---

for example if a user is using a website in that if a user is typing a word ...

Self join would do it meaning, you have to join your table with itself, apply your logic.

rortizsoftware (4/6/2012)

---

Usually I do everything in .net, so I'm not familiar with sending out emails from a stored proc. I'll have to research that. Do you have any...

PaulB-TheOneAndOnly (4/6/2012)

---

rortizsoftware (4/6/2012)

---

I'm new to using SSIS and I'm trying to figure out how to run a query, get a bunch of email addresses from the database, and then send...

Adding to Gail's point, looking at your questions it looks like you may want to refresh your "Table Partitioning 101" skills, start here http://msdn.microsoft.com/en-us/library/ms190787.aspx

rortizsoftware (4/6/2012)

---

I'm new to using SSIS and I'm trying to figure out how to run a query, get a bunch of email addresses from the database, and then send an...

pduback (4/6/2012)

---

Is this possible?? I know to use insert,update, delete against an iseries table(through a linked server) the file on the iseries needs to be journaled. So how do I...

gwphillipson (4/6/2012)

---

Can anyone point me in the right direction for any info on replicating SQL 2005 standard data on my desktop pc and publishing the data to my VPS which...

This is what I usually do.

1- Write down five questions about the topic, data mining in this case.

2- Go...