LutzM (4/23/2011)

---

GilaMonster (4/23/2011)

---

Want to swap? I'm having some amusement with...

WayneS (4/22/2011)

---

Koen Verbeeck (4/22/2011)

---

WayneS (4/22/2011)

---

Did you know that most windows programs (including SSMS; not Notepad) allow you to select COLUMNS of text? Position the cursor at the starting position, and...

titan2782 (4/22/2011)

---

thanks for that info. After i made the changes, it looks like the query runs slower now. Even though the row size is 6kb and I dropped/rebuilt all indexes....

mtillman-921105 (4/12/2011)

---

'Anyone else using their computer as a source for their home stereo? Your advice is welcome here.

I have an old PC that I plan to use for a...

Bozohead Jones (4/22/2011)

---

Thank you for quick reply!

Soon after I posted, I believe I've figured this out. The package has a hardcoded path to a dtsConfig in the old project!...

Also, once you change the connection, you have to go through and manually change every task that used that connection, primarily to make sure the tables and rows that are...

Bozohead Jones (4/22/2011)

---

I'm attempting to use an old package as a starting point for a new project. Of course, the first thing I want to do is point it...

JCSQL (4/22/2011)

---

This is VERY frustrating as I actually have this working on several servers but it is not working in my current code. I KNOW I am missing something stupid...

This should be a good starting place for you

http://msdn.microsoft.com/en-us/library/ms175862.aspx

kazim.raza (4/21/2011)

---

Hi,

I need to prepare a report that describes user status and the time spent in transitioning from one status to another, for instance,

User arrives at work, logs in, and...

Oh good. You should look into making them SPARSE columns. You can save a lot of space that way.

http://msdn.microsoft.com/en-us/library/cc280604.aspx

If they aren't in the index,...

dianaansari (4/21/2011)

---

I am using SQL to enter data from asp.net/c# language. A link button on asp.net webpage will allow the user to enter the data into and that data will...

dianaansari (4/21/2011)

---

I do not know if I am in the right thread, but I am having a SQL issue.

When I debug my web-page it shows me this error:

Must declare...

titan2782 (4/21/2011)

---

I have a table with 100m+ rows. We're seeing very bad performance on queries as the data grows. I noticed that the row size is pretty big (10190) and...

kwoznica (4/21/2011)

---

Stefan,

I am going to give this a go keeping in mind all the points you brought up. If you have some time can you look at the code...