YSLGuru (9/18/2012)

---

Yes. When...

May be MS, but that shouldn't stop you from adding an index if it helps. I worked ith PeopleSoft developers and added several indexes to PeopleSoft systems to support...

MissTippsInOz (9/17/2012)

---

I hope this doesn't come across as rude, but I work for a very large company,...

That is a very small database. Wait until you work with a system like PeopleSoft with 50,000+ tables. Good thing the application handles the security there.

Fixed the code:

declare @members table (mid int, dob date, fname varchar(10), lname varchar(10));

insert into @members

values (1,'1959-08-29','a','a'),(2,'1959-09-29','b','a'),(3,'1959-10-29','c','a'),(4,'2011-09-20','a','d');

select

m.fname + ' ' + m.lname

from

@members m

where

...

Try this:

select

m.fname + ' ' + m.lname

from

members m

where

m.dob >= cast(getdate() as date) and

m.dob <...

Could be an indexing issue as well. Not using MDW so only a guess.

Let us make it easier for others:

http://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspx

Well, at least I did post this on the actual thread!

rhythmk (9/18/2012)

---

boehnc (9/17/2012)

---

this is basically the code...this join... left join UserView.vwEncounterDiagnosis d on d.VisitId=a.VisitId...will give me multiple rows per patient

i...

You will need to apply the service pack to the new instance. Each instance has its own set of files.

This article should help with understanding transaction log backups:

http://www.sqlservercentral.com/articles/Administration/64582/

I would also recommend reading about these in Books Online, the SQL Server Help System.

kramaswamy (9/18/2012)

---

Hi all,

I'm a bit confused regarding the different modes of backup.

If I understand correctly, a FULL backup takes a backup of the entire database, and then takes a backup...

SQLRNNR (9/18/2012)

---

Lynn Pettis (9/18/2012)

---

Flat file, 150,000 columns, SQL Server only allows 1,024 columns per table. The flat file needs to be imported into Excel spreadsheets.

I'm not in a postion...

Only thing that comes to my mind is a custom written application. Even then it may not doable due to restrictions in Excel and the number of columns it...

Flat file, 150,000 columns, SQL Server only allows 1,024 columns per table. The flat file needs to be imported into Excel spreadsheets.

I'm not in a postion to help.