EthanZ (2/5/2013)

---

I administer a SQL2008 server, the server is being handed over to another dept to manage, they are moving over all the databases and maintaining all roles etc. Once...

The link you are referring to is the first one in my signature. Unfortunately it doesn't do much good here because the OP is " in charge of creating a...

Welcome... it would help if you provided DDL and sample data and what you expect to see as a result. There's a link to a posting guide somewhere, one...

Grant Fritchey (2/5/2013)

---

Best way to learn the basics is by doing. You've already been pointed out how to get a copy of SQL Server to play with. Next up, a...

If you want to learn the general SQL then you can get whatever your book is using,

lots of open source DB's and I think all vendors have an express...

I used Litespeed on a 2005/2008 R2 SQL Cluster. Like many mentioned a lot of factors, disk IO being a major part. Native backup would have never worked out...

Did you specify the double quotes as the text qualifier? if not it'll read the comma's inside the quotes...

example:

"test, test1,test2","xyz name","some id"

will read:

Col1 Col2 ...

anthony.green (1/23/2013)

---

Solarwinds, is primarily a network monitoring tool but has branched out into a IT Management & monitoring solutions

http://www.solarwinds.com/

I evaluated it a good few years ago now and it wasn't...

I think everyone else has iterated the same thing. What is the actual goal of the migration? That would help in determining a strategy. If you're goal is to...

Who's the owner of the package vs. the account that's running it? dtsx packages will ask for saved credentials if the person running it is different from the owner. ...

MyDoggieJessie (1/22/2013)

---

Crude, but this will work, just loop through a directory (if you are able to execute xp_cmdshell, if not I'm sure there's a powershell script lingering around)DECLARE

...

I think this is what you're looking for...

Providing easily consumable sample data makes it easier for people to help and more likely...

--Setup Sample Data

declare @transactions as table (Receivers char(1), Payers...

This post may help:

http://www.sqlservercentral.com/Forums/Topic262014-17-1.aspx

ALTER DATABASE DBName ADD FILE

(NAME =F_TBL_201301,FILENAME ="<location>\F_TBL_201301.ndf",

SIZE = 50MB, MAXSIZE = unlimited, FILEGROWTH = 10%

) TO FILEGROUP FG_TBL

ALTER PARTITION SCHEME PS_TBL NEXT USED...

Mykre (1/15/2013)

---

I have seen a system where it would look at a processed directory and process all of the files in that directory, when the package had finished with a...