sqlserver2000date.blogspot.com

indexandkey.blogspot.com

index and key: Index Tuning Wizard

http://indexandkey.blogspot.com/2012/03/index-tuning-wizard_30.html

Friday, March 30, 2012. I'd like to use Index Tuning Wizard. I created a workload trace file with. SQL Profiler, then I start the wizard but it ends up with message that there. Are no events and queries that can be tuned against current database. I used trace template 'SQLProfilerTuning.tdf', so there are only. RPC:Completed and SQL:BatchCompleted events, which should be OK, but may be. It is a problem that we use stored procedures for data manipulation, in fact. Be OK, but may be. Manipulation, in fact.

indexesanddeadlocks.blogspot.com

Indexes and Deadlocks: Information_Schema Question

http://indexesanddeadlocks.blogspot.com/2012/03/informationschema-question_3024.html

Friday, March 30, 2012. I am selecting some column info from information schema like this:. SELECT COLUMN NAME,DATA TYPE,CHARACTER MAXIMUM LENGTH,IS NULLABLE. FROM test.INFORMATION SCHEMA.COLUMNS. WHERE TABLE NAME = N'Test Table'. I am doing this via OleDb connection to Sql2000. I connect as the owner of the database/tables. I connect to the database for which I am seeking the information. I get rows returned for some tables, but not others. At first, when I. Ah ha, I think, I have it! I am selecting som...

indexesanddeadlocks.blogspot.com

Indexes and Deadlocks: INFORMATION_SCHEMA.PARAMETERS

http://indexesanddeadlocks.blogspot.com/2012/03/informationschemaparameters_30.html

Friday, March 30, 2012. Is there any way to find out the stored procedure output paramters like I. Can findout the input params through following query but I want to findout. The output params list. SELECT Specific Name, Parameter Name FROM INFORMATION SCHEMA.PARAMETERS. CHARACTER MAXIMUM LENGTH,. From INFORMATION SCHEMA.PARAMETERS. Where specific name = @.chvProcName. Order by ordinal position. Look for PARAMETER MODE it will have a value of OUT. Http:/ sqlservercode.blogspot.com/. The output params list.

indexesanddeadlocks.blogspot.com

Indexes and Deadlocks: INFORMATION_SCHEMA.COLUMNS query

http://indexesanddeadlocks.blogspot.com/2012/03/informationschemacolumns-query_1978.html

Friday, March 30, 2012. INFORMATION SCHEMA.COLUMNS query. Im trying to run the following query but keep getting an error. Sever name].[database name].INFORMATION SCHEMA.COLUMNS. WHERE TABLE NAME = [table name]. Server: Msg 7314, Level 16, State 1, Line 2. OLE DB provider [sever name] does not contain table. Database name]"."INFORMATION SCHEMA"."COLUMNS". The table either. Does not exist or the current user does not have permissions on that. OLE DB error trace [Non-interface error: OLE DB provider does not.

indexesanddeadlocks.blogspot.com

Indexes and Deadlocks: INFORMATION_SCHEMA.SCHEMATA does not return all rows on SQL 2005

http://indexesanddeadlocks.blogspot.com/2012/03/informationschemaschemata-does-not.html

Friday, March 30, 2012. INFORMATION SCHEMA.SCHEMATA does not return all rows on SQL 2005. In SQL 2000, the following query used to return all the database names:. SELECT CATALOG NAME FROM INFORMATION SCHEMA.SCHEMATA. However, in SQL 2005, it just returns "master" as the database (that. Too a number of times). Can someone please confirm if this is a bug in SQL 2005? Although I could use sp catalogs rowset;2, I prefer using ANSI SQL. Thank you in advance for your help. Never have been a list of databases).

indexandkey.blogspot.com

index and key: Index Tuning Multiple Queries

http://indexandkey.blogspot.com/2012/03/index-tuning-multiple-queries.html

Friday, March 30, 2012. Index Tuning Multiple Queries. I'm attempting to run the Index Tuning Wizard against multiple queries at. Once (dozens) in SQL Query Analyzer. I put a GO at the end of them to. Indicate a batch, select all the queries GO, but the wizard only analyzes. The first query. I'm also avoiding the production hit of the Profiler,. Unless a last resort. Have you tried putting them into a .sql file and using that? I'm attempting to run the Index Tuning Wizard against multiple queries at.

indexesanddeadlocks.blogspot.com

Indexes and Deadlocks: Information_Shema as a user in Master database

http://indexesanddeadlocks.blogspot.com/2012/03/informationshema-as-user-in-master.html

Friday, March 30, 2012. Information Shema as a user in Master database. Recently, I was running a script like:. Declare @.sql nvarchar(4000). Declare @.db sysname ; set @.db = DB NAME(). Declare @.u sysname ; set @.u = QUOTENAME('db executor'). Set @.sql ='select ''grant exec on '' QUOTENAME(ROUTINE SCHEMA) ''.''. QUOTENAME(ROUTINE NAME) '' TO ' @.u ''' FROM. INFORMATION SCHEMA.ROUTINES '. 039;WHERE OBJECTPROPERTY(OBJECT ID(ROUTINE NAME),'. 039;IsMSShipped'') = 0'. Things happened on sql server. A remote...

indexandkey.blogspot.com

index and key: index tuning wizard

http://indexandkey.blogspot.com/2012/03/index-tuning-wizard_3892.html

Friday, March 30, 2012. I have a query that looks something like this:. Select fields from tableA. Select fields from tableB. Select fields from tableC. I want to try to run the Index Tuning Wizard on all of the queries in the. Window. However, whenever I try, the ITW tells me "There are no events in. The workload. Either the trace file contains no sql batch or RPC events or. The sql script contained no sql queries." If I select one line and run the. Each line but that didn't help. Thanks for the help.

importingaccessdb.blogspot.com

Importing Access DB: imports microsoft.sqlserver.dts.pipeline does not work

http://importingaccessdb.blogspot.com/2012/03/imports-microsoftsqlserverdtspipeline.html

Friday, March 30, 2012. Imports microsoft.sqlserver.dts.pipeline does not work. I have been trying to follow/implement the examples in the following help topics (thanks to Jamie for these links). Http:/ msdn2.microsoft.com/en-us/library/ms345167.aspx). Connecting Data Flow Components Programmatically. Http:/ msdn2.microsoft.com/en-us/library/ms136086.aspx). The problem I am having is that MainPipe. Can anyone tell what I am missing? Here is my code:. Microsoft SQL Server Integration Services Script Task.

importingaccessdb.blogspot.com

Importing Access DB: Importing XML Sample file and XML Schema

http://importingaccessdb.blogspot.com/2012/03/importing-xml-sample-file-and-xml.html

Friday, March 30, 2012. Importing XML Sample file and XML Schema. I recently received a schema file from a vendor to import into my SQL Server. I am new to XML and have been reading all I can. I tried doing a Bulk Load. In a DTS Package, but it does not read the schema as the correct file format. Asking me ANSI, Unicode, etc). I have a sample data file to test with but. It does not seem to be working. Can anyone give any insight on the easiest. Way to do this? Need to import on a schedule. Thanks. News:5...