Viewing 15 posts - 3,211 through 3,225 (of 7,187 total)
If I had thousands of files, I think I'd prefer to use xp_cmdshell to run dir /b and pull all the file names into the staging table in one go....
March 31, 2015 at 7:38 am
I didn't even know you could do that. Can I ask why you want to, please? I can't think of any problems it would cause, since your applications...
March 27, 2015 at 10:22 am
Yes, expand the files manually if you can, at a time of low activity. I would recommend that you leave auto-grow enabled, in case of any unexpected rapid growth....
March 27, 2015 at 9:41 am
Here's one example[/url]. There are many more out there if you search for them. You may find it helps to add other columns to the table to suit...
March 27, 2015 at 9:33 am
You could do some fancy date arithmetic, but it's probably easier just to create a calendar table and join to that where the day datepart is 1.
John
March 27, 2015 at 9:22 am
Yes, you can use SSIS, bcp or BULK INSERT, whichever works best for you. There are other cruder ways of doing it as well, such as building a set...
March 27, 2015 at 3:44 am
This is why I rarely use the GUI for stuff like this - you never know what it's going to do behind the scenes. Use sp_addrole to create the...
March 25, 2015 at 9:19 am
Yes, or he could tell us why he is "unable to log in via Windows authentication". I'd be surprised if he's tried exactly what I suggested in my first...
March 25, 2015 at 6:35 am
Vijay
Yes, log on to the server as an administrator, start SQL Server in single user mode, connect locally using Windows authentication, change the sa password, and restart SQL Server.
John
March 25, 2015 at 3:14 am
Kathy
I would categorise it as a user database (although I don't think it's all that important which pigeon-hole you choose to put it in). It can't do any harm...
March 23, 2015 at 10:44 am
I'm not saying that you should necessarily use something else. I'm saying that it's possible for index usage stats to be cleared between the last time the database was...
March 17, 2015 at 8:45 am
There are certain events that cause index usage stats to be reset, and it looks as if taking a database offline is one of them. If you want to...
March 17, 2015 at 8:37 am
OK, so you don't need 6000 columns. Your table will look a bit like this:
CREATE TABLE StockData (
CheckDate date NOT NULL,
StockCode int NOT NULL,
StockHigh decimal(9,2) NOT NULL
StockLow decimal(9,2) NOT...
March 16, 2015 at 5:25 am
Does each stock type have the same 30 attributes (columns)? Please will you give some examples?
John
March 16, 2015 at 5:12 am
Viewing 15 posts - 3,211 through 3,225 (of 7,187 total)