Hi,

You can download .mdf files from here http://msftdbprodsamples.codeplex.com/

and then after restoring them make backup (.bak) files.

Regards

IgorMi

Hi

You can use this code to determine if a table has primary key (a condition for 2NF)

declare @2NF_flag bit

set @2NF_flag=convert(bit,0)

if objectproperty(object_id('[schema].[Table]'),'IsUserTable') = 1

if (objectproperty(object_id('[schema].[Table]'),'TableHasPrimaryKey')=1

/*or objectproperty(object_id('[schema].[Table]'),'TableHasClustIndex')=1*/)

...

Hi

If you maintain your log file on the best then you're close to the optimal number of VLFs. This link can help you http://www.sqlskills.com/blogs/kimberly/8-steps-to-better-transaction-log-throughput/

Regards

IgorMi

Hi

Interesting questions.

For example the following simple code would help you find the computed columns (violation of 3th normal form) for a table:

select t.name [TableName], c.name [ColumnName]

from sys.tables t

join sys.computed_columns c...

kapil_kk (4/18/2013)

---

oopes,

I think I have misunderstood the way to execute the given query...

After seeing comments First Attempts, second, third I executed one by one those insert query and forget about...

Hi,

We had similar problem recently. Do you have the option "with recompile" in your stored procedure? We've resolved it by attaching that option to the sp.

Regards

IgorMi

What version of SQL Server you use. Check it in msdn library.

I presume you use FREETEXT() and/or CANTAINS(). Have you tried both?

Regards

IgorMi

Hi,

Full Text Search supports more than 50 languages - http://msdn.microsoft.com/en-us/library/ms142571(v=sql.105).aspx

Regards

IgorMi

Hi

Yes...

Hi

So, what is the difference between a query with missing index on a column in its WHERE clause executed as exec sp_prepexec @sql_stmt or exec sp_executesql @sql_stmt, and the same...

Hi

It depends on other factors. For example it depends what settings are ON and OFF when your connection (ODBC,OLE DB) passes the queries to SQL Server and what the setting...

Hi

Another help could be found here

http://www.idera.com/Downloads/WhitePapers/Top10SQLPerf.pdf

The SQL service account must be granted the "Lock pages in memory" user right.

Regards

IgorMi

SQL ORACLE (4/3/2013)

---

The execution plan is saved by SQL Server after the first run. The plan will be changed if you changed your query.

If you run the same query...

So it seems that according to table on http://msdn.microsoft.com/en-us/library/ms175088(v=sql.105).aspx the default settings does not matter because it all depends on the ODBC connection settings which overwrite most of the settings.

SQL ORACLE (4/3/2013)

---

Just my two cents.

The execution plan is saved within the cashe allocated to SQL Server instance. It is not related to the other setting outside SQL Server.

The ANSI...