Hi

Here are some links:

https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/

http://msdn.microsoft.com/en-us/library/aa964122(SQL.90).aspx

http://technet.microsoft.com/en-us/sqlserver/gg545008.aspx

Regards

IgorMi

Hi

You can use these links to start:

http://msdn.microsoft.com/en-us/library/ms189852(v=sql.105).aspx

http://msdn.microsoft.com/en-us/library/ms187103(v=sql.105).aspx

It's available from sql server 2012.

ChrisM@Work (5/3/2013)

---

What is the source for this statement? ...

ChrisM@Work (5/3/2013)

---

IgorMi (5/3/2013)

---

ChrisM@Work (5/3/2013)

---

IgorMi (5/3/2013)

---

Queries having...

ChrisM@Work (5/3/2013)

---

IgorMi (5/3/2013)

---

Queries having WHERE clause...

Filters in queries having WHERE clause...

IT researcher (5/3/2013)

---

Ok. But while creating PATH type index is there needed to specify the path which i use?

I don't know much about xml indexing. But for other...

Hi,

Why do you need two databases? What is the advantage of having two databases?

Having one database with a good backup strategy is enough. This is in use at quite big...

Hi

SELECT sum(CONVERT(float, ft.amount))

FROM filetransaction ft

WHERE ft.fileid <>332 and ISNUMERIC(ft.amount)=1

Check this also http://www.sqlservercentral.com/articles/IsNumeric/71512/

Regards

IgorMi

Hi,

Because you use exist() you should create FOR PATH type xml index.

Regards

IgorMi

gcresse (5/2/2013)

---

Thanks Igor. The link appears to be broken, but we ended up not uninstalling afterall. I believe I could have gone through the Control Panel > Add/Remove programs...

Hi,

I got interested in your question.

Did you check this http://cathydumas.com/2012/04/23/changing-an-analysis-services-instance-to-tabular-mode/

Please provide a feedback for this.

Regards,

IgorMi

Hi,

As you said you have big tables, then enabling trace flag 2371 can be of asset for your databases. See this

http://blogs.msdn.com/b/saponsqlserver/archive/2011/09/07/changes-to-automatic-update-statistics-in-sql-server-traceflag-2371.aspx

Regards,

IgorMi

Hi,

Do you have a snapshot created for that database? If yes, then you must drop it first.

You can also check if you have any opened sessions to the database you...