+1

milos.radivojevic (2/27/2014)

---

Igor,

An index seek in your second example has been chosen by the optimizer because the query is not parametrized. You simply concatenated the query text and the resolution about...

Yes, you can extend the your query with sys.objects, sys.tables, sys.procedures and etc...

Just explore a bit.

dbcc freeproccache

exec sp_executesql N'select * from test where (name like @name or @name = ''All'' ) ',N'@name nvarchar(400)',@name = N'wmi%'

--index scan

vs.

dbcc freeproccache

declare @name nvarchar(400)

set @name = N'wmi%'

declare @dyn_sql nvarchar(1000)

set @dyn_sql...

I got interested in your question and make some tests:

dbcc freeproccache

exec sp_executesql N'select * from test where coalesce(name,N'''') like @name',N'@name nvarchar(400)',@name = N'wmi%'

/* You have compiled the statement with the...

This is a nice article. I've used it several times and got improving results by changing...

If your files are empty then you can perform

DBCC SHRINKFILE(LogicalNameOfFileToRemove, EMPTYFILE)

But you say "..no data loss"?

Can you empty/remove a non-empty file? You cannot.

Why do you need to merge the ndf...

JohnFTamburo (2/27/2014)

---

AK1516 (2/25/2014)

---

Can some help me reffer to a good document or script to do the table partitioning for a 500gb in sliding window technique ?

In my 4 year...

Thanks.

This is valid for all versions starting from sql server 2005+

Will this help you?

declare @country nvarchar(20)

set @country = N'en_US'

select X.value('contentId[1]','varchar(100)') as ContentId,

X.value('content[1]', 'varchar(100)') as Content

FROM XMLwithOpenXML A

CROSS APPLY A.xmldata.nodes('/Internationalization/contentRecords/contentRecord') as N(X)

WHERE A.xmldata.exist('/Internationalization/contentRecords[@locale = sql:variable("@country")]') = 1

Regards,

Igor

This is a good resource link:

http://dennyglee.com/2012/06/28/microsoft-sql-server-analysis-services-multidimensional-performance-and-operations-guide/

In SSMS:

Tools -> Options -> SQL Server object explorer -> Scripting: in Object scripting options check the Script permissions.

EricEyster (2/25/2014)

---

Is the query scanning or seeking on the index? The optimizer will always list the perfect index, but in many cases a close index is good enough. If you...

Easy way is to import the flat file into excel file and than sort by that column (if the file is not huge, of course).

It should be a value that is not an integer.

Can you check in a way if you don't have non-integer values in your flat file?