mymail.default (4/9/2012)

---

Hello All,

Little stumped!

Have a simple select stmt (SQL 2008):

1. Returns the correct result when ran alone in management studio

2. Returns a value (this value was an older...

Please read and follow the instructions in these two articles:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Doing so will get you the best answers possible to you problem.

Since you are doing a nightly full backup, why not just restore that backup for your BI/Datamining people?

out

Looking at the estimated plan, however, it looks like there is a missing index as well. Please post the DDL for the table(s) involved including all indexes that are...

Here is some code, but it is untested as you didn't provide all the required information to do any testing (no DDL, sample data in a readily consumable format).

with cteStudentData...

If you select Tools in the menu, then Options, Designers, Table and Database Designers you will find an option that will allow you to modify a table that needs to...

lukebaker (4/9/2012)

---

Ok so it has been SOLVED. Would like to thank all the people that helped. Below is the code that worked for me.

ALTER TRIGGER tg_UpdateTraining

ON Training

AFTER...

I understand how networks work, it seems to be mandatory now a days at home with everyone having their own computers.

I would like to learn more about NAS/SAN storage, but...

The table msdb.dbo.backupset has a column that tells you the recovery model of the database. You could query previous backups of the database to determine what recovery model the...

Need the sample data in a format that is readily consumable. A series of INSERT INTO statments fits that bill.

Here is some more code to help you:

declare @TestTab table (

testid int identity(1,1),

startdate datetime,

enddate datetime);

insert into @TestTab(startdate, enddate)

select...

ssssqlguy (4/9/2012)

---

You can do what karamaswamy above mentioned; or you can also create an indexed view against these tables (assuming their schema is the same). This way, your queries...

It also depends on what version of MS SQL Server you are running.

I really don't feel like going through all the previous posts, so I'm just going to ask, have we been given all the requested information in a readily consumable format...