It might be possible that there are rows with length > 15 selected early on in the query plan which are filtered out later.

If you change the query, the query...

Good point.

It might be easier to create a stored procedure that checks if the job should run or not.

If...

Unfortunately you cannot specify many rules in a SQL Server Agent schedule.

It seems you have to create 10 different schedules, each for one single day.

Using SSMS:

dbagroup,portnumber (add a comma between)

Make sure the TCP/IP protocol is enabled.

edit: instance name is not needed

Take a look at GROUP BY ROLLUP.

One server doesn't accidentally have another keyboard layout?

Not that straight forward it seems.

Take a look at this topic:

http://stackoverflow.com/questions/1059105/how-to-remove-server-name-items-from-history-of-sql-server-management-studio

sqlserver12345 (11/18/2013)

---

Can I generate PDF extracts while extracting data from SQL databases?

I have been able to create .doc,.txt and .html files but when I try to generate PDF it fails.The...

Please read the entire MSDN page you linked to.

The following SQL Server Database Engine features are supported in the next version of SQL Server, but will be removed in a...

Not with SSIS out of the box.

There are some 3rd party components that can do this though.

Alternatives are programmatically creating SSIS packages, using .NET or maybe BIML.

(if you know a...

You cannot change the metadata of a data flow dynamically.

Each different table structure needs a different data flow.

Maybe you need to take another approach. You could try bcp to dump...

L' Eomot Inversé (11/18/2013)

---

Congrats.

When do you...

I believe number 2.

Went over 11,000 points a while back and I also managed to wringle myself into the top 10 (sorry Paul).

😎 :w00t:

As...