dharmendra.mittal (3/25/2014)

---

Hi all,

I need to design a SSIS for uploading between 5-6 flat files each month.

These flat files are not the same format. Like .xls,.txt,.csv....

I can achieve it by creating...

I believe LOP_CKPT_END (LOP=Log Operation, CKPT=CheckPoint) is an entry made by Sql Server to the Transaction Log during a CheckPoint (You can read more about CheckPoints here http://technet.microsoft.com/en-us/library/ms189573.aspx).

As...

CookieMonster (3/25/2014)

---

Hi All,

I need to insert approximately 500k rows into sql, but on each insert i need to get the inserted row id so i can perform insert into another...

I can't open the plan either.

This kind of trouble shooting can be a little difficult without visibility of what's going on in the plan.

It should "just work" exactly as Grant...

The Stairway to Database Design here on SSC should be a good read for you.

http://www.sqlservercentral.com/articles/Stairway+Series/70199/

OTPS (3/20/2014)

---

I can see the concept but not the execution. How would I set a variable to something like the value of the enumerator so if it was zero I...

pujain (3/20/2014)

---

Hi, I have a column with datatype nvarchar where we are storing XML string, e.g below

<?xml version='1.0' encoding='UTF-8'?><root available-locales="en_GB" default-locale="en_GB"><Title language-id="en_GB">Cookies</Title></root>

now how can I pull "Cookies" from this string...

This isn't very clear, at least not to me.

Are you saying that following an import using the Import Export Wizard that you get a different number of rows at the...

domingo.sqlservercentral (3/18/2014)

---

No, I don't know. Do you mean about upload of database backup file? ...

rraza (3/15/2014)

---

Can anyoine answer this interview question Please??

A DBA accidentally dropped a critical highly transactional table in production. Walk me through the exact procedure to restore it without taking the...

If you can, post the actual execution plan.

You might get a few pointers here as to why the code might be slow.

It's important you determine what your applications requirements are and how much data it is acceptable can be lost.

You would...

StephenNL (3/12/2014)

---

Hi dudes...

There is a database and a ldf file-working properly so far.

When I try to make a maintenance plan for backup, management studio just finds the mdf (which, by...

Thanks for all the responses. 🙂

LEN is a valid Sql Server...