Thread: ODBC from a SQL script

"Maybe not by much", well that depends. For a large table, that could indeed be much. Say that you need to search a table with 100 million rows for people name John Smith in Seattle. With one index each on first name, last name and City, I would expect the optimizer to give up and scan the table. With a compositie index, the optimizer would urely use it. > And if only the first column is specified in the where, the...

Fred Yes, I have had a client who has Express Edition and we ran packages by using dtexec  with out problems > Thanks Uri, > [quoted text clipped - 31 lines] >>>>> Does anyone know why Microsoft is not providing 64 Bit ODBC drivers >>>>> for targets like Excel, Access and Text files?

Note that partitioning is an ADVANCED topic, and you really need to spend some time/effort knowing what you need and how to best accomplish it or you will be setting yourself up for some disappointment and/or pain in the future.  Good thing to hire a consultant for a day or two IMHO. Signature Kevin G. Boles Indicium Resources, Inc. SQL Server MVP kgboles a earthlink dt net >I am looking to partition my table for 52 weeks (Per...

The Query Optimizer will choose the best index for a query, not the best group of indexes. So, if you need to filter by two columns, then put both in the index. To get performance from an index, you want to get an index seek and the Query Optimizer can only do a seek for columns that head the index, or are listed in order (ColA, ColB, etc). > So I take it that if both columns are specified in the where, the > composite index is...

... but in the end, the tool is (was)  just a GUI around sp_configure and ALTER ENDOINT. Might be easier to use in some cases than dig into policies... Signature Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi > It is now implemented via Policy-based Management (PBM). > > What happened to the Surface Area Configuration in 2008? > >...

Muhammad, The difficulty will be in interpreting the different date formats in the character strings and determining which format the date is in.  For some examples. Two digit years are very hard to recognize: select convert(datetime, '08/12/31', 1) -- 2031-08-12 00:00:00.000 select convert(datetime, '08/12/31', 2) -- 2008-12-31 00:00:00.000 select convert(datetime, '08/12/31', 3) -- 2031-12-08...

Absolutely but also be careful even in OLTP apps you still need to do things like rebuild / create indexes, backups, DBCC's etc that can all benefit from parallel operations but HT can also hurt them as well. But it does depend on the workload for sure. Signature Andrew J. Kelly   SQL MVP Solid Quality Mentors > I would also add that you need to review the type of processing.  If you > are mainly running an...

Hi Jay In addition to the Books Online, you should also get family the SQL Server Developer Center on MSDN. There is a huge collection of whitepapers to educate you on aspects of SQL Server you might not have been aware of. Here's one on Policy Based Management: http://msdn.microsoft.com/en-us/library/dd938891.aspx Signature HTH Kalen ---------------------------------------- Kalen Delaney SQL Server MVP www.SQLServerInternals.com >...

Note that you can run the same script on multiple instances from SQL 2008 SSMS by creating a registered server group with the desired servers and opening a multi-server query window from that group node. A command-line method: 1) Create a script file for this task (e.g. SetSimpleRecovery.sql): DECLARE     @AlterStatement varchar(MAX),     @DatabaseName sysname; DECLARE DatabaseList CURSOR...

Run select * from sys.master_files, check the folders used in the physical_name column, and it's likely, though no guarantee, that your database files may be in the same folders. Linchi > I just detached an sql server 2005 db. Where can I find it? > [quoted text clipped - 206 lines] > http://www.eggheadcafe.com/tutorials/aspnet/0af43149-8fa7-4ab8-8d08-e885090f1a8d /aspnet-data-control-seri.aspx > .