A materialized view in SQL Server is a clustered index. This means that the data that defines the view will be stored within the view at the leaf level of...

There is a setting called 'Optimize for Ad Hoc Workload' that could help you out. Instead of storing a plan each time a query is run, the first time it's...

It's just like buying any other piece of hardware, the more money you spend, the better off you are. My current laptop is a MacBook Pro with 16gb of memory....

PiMané (10/22/2012)

---

Thanks Grant... Still reading your book on query...

harri.reddy (10/22/2012)

---

well,

they gave me some tables(approx 9) tables and field that they want to fecth only those field.

they all r master table.so do i need to make table that connect...

sql-lover (10/22/2012)

---

Grant Fritchey (10/22/2012)

---

sql-lover (10/22/2012)

---

I maybe wrong about this, but wanted to check or revise my own concepts.

I thought deadlocks (most of them) were due poor or bad code; a...

sql-lover (10/22/2012)

---

I maybe wrong about this, but wanted to check or revise my own concepts.

I thought deadlocks (most of them) were due poor or bad code; a process pinning other...

I used to use CodeSmith. But that was when they were hosted on CodePlex. It's moved to GoogleCode [/url]and I'm not sure it's the same. Still, might be worth checking...

But, you can get it if you need it from 3rd party products such as Red Gate SQL Storage Compress[/url].

They gave you fields & data lengths, cool. But are they defined as tables or as objects or just as interesting pieces of information that the business wants to see?...

And the godfather of Extended Events has an XEvent A Day series of blog posts. Jonathan is frequently a better resource for this stuff than Microsoft.

You have to include the database name if the database resides on the same server:

SELECT *

FROM MyDatabase.MySchema.MyTable;

That will get it done. You can then join on the appropriate column.

Just know that the backup size is not just the data size. It also includes some header information (very small) and open transactions that are rolled forward or rolled back...

If you look to the left side of the screen there is a link there labeled "Stairways." That is a series of lesson plans on various aspects of becoming a...

Yes, someone who achieves Senior should have special knowledge of parts of SQL Server and should be a go-to resource. I agree.