Munabhai (3/28/2012)

---

create table omar.dbo.a123

(

contactid char(10),

firstname varchar(20),

emailaddress varchar(20)

)

CREATE NONCLUSTERED INDEX IX_NC_PresidentNumber

ON omar.dbo.a123 (EmailAddress)

Let's assume,...

Not to sure what you are looking for here. It would help if you could post the DDL (CREATE TABLE statement) for the table, some sample data (as a...

SQLRNNR (3/28/2012)

---

JeffRush (3/28/2012)

---

In my opinion you should provide your failed queries so we can guide you in the right direction.

No one is likely (hopefully) going to just answer your homework...

I did use some SQL Logins at a previous employer but those were limited to the DBA group to get access to the SQL Server systems when connecting from home...

Going out on a limb here, I don't think so. From BOL:

The Integration Services service is not required if you only want to design and execute Integration Services packages....

May I ask the obvious then, why isn't there a stored procedure in...

I would use NT Groups and NT Logins. When users are created, they get added to the appropriate groups in AD and have the appropriate access provided by assigning...

Not sure if my other question was answered or not, so to clarify I'll ask again. Each dynamic insert statement created, are they the same or can they be...

Sourav-657741 (3/28/2012)

---

If I need to run 1272 indexes in batches, then I will have to go by doing this in a manual process....

Do you think this is what can be...

So, your code dynamically builds the insert statements? Not being a VB programmer, are the insert statments the same everytime they are built?

Sourav-657741 (3/28/2012)

---

Hello,

I want to consider two aspects --

1. LDF file should not grow too much...so that at Production server, my drive doesn't run out of space.

2. The size of the...

Welsh Corgi (3/28/2012)

---

Lynn Pettis (3/28/2012)

---

First, is...

First, is it me or does...

Directly from Books Online:

If GROUP BY is specified, the view select list must contain a COUNT_BIG(*) expression, and the view definition cannot specify HAVING, CUBE, or ROLLUP.

You need to add...

Storing the the image data in the database keeps things in one place. You capture the images in your backups so that if a restore is needed, you won't...