Viewing 15 posts - 406 through 420 (of 2,647 total)
PaulB-TheOneAndOnly (7/26/2012)
SQLKnowItAll (7/26/2012)
However... I could maybe put each customer into their own schema? and build those schemas on their own filegroups? Hmm... Just thinking out loud.
Why don't you push...
Jared
CE - Microsoft
July 26, 2012 at 9:53 am
You have no end of line. You have to add something (depending on your file) like a \'n' (remove the single quotes around the n):
10.0
9
1 ...
Jared
CE - Microsoft
July 26, 2012 at 9:44 am
Please tell us what you did so that others can resolve the problem it it happens to them.
Jared
CE - Microsoft
July 26, 2012 at 9:38 am
Is SA your only login? There must be others that work?
Jared
CE - Microsoft
July 26, 2012 at 8:59 am
PaulB-TheOneAndOnly (7/26/2012)
SQLKnowItAll (7/26/2012)
1. Std. Ed.
Do poor's-man partitioning, a table by customer exposing the bunch as a view joining all of them.
SQLKnowItAll (7/26/2012)
Jared
CE - Microsoft
July 26, 2012 at 8:56 am
Log in as someone who is not SA and fix your trigger.
Jared
CE - Microsoft
July 26, 2012 at 8:50 am
PaulB-TheOneAndOnly (7/26/2012)
SQLKnowItAll (7/26/2012)
PaulB-TheOneAndOnly (7/26/2012)
In terms of restoring a subset of the database I would start by backing...
Jared
CE - Microsoft
July 26, 2012 at 8:46 am
PaulB-TheOneAndOnly (7/26/2012)
In terms of restoring a subset of the database I would start by backing up subsets...
Jared
CE - Microsoft
July 26, 2012 at 8:27 am
Yeah, my first thought is to set up some auditing triggers and put some kind of identifier to allow them to restore along several different measures; i.e. a specific item...
Jared
CE - Microsoft
July 26, 2012 at 7:43 am
Go to the command line on that machine and type "net use M: \\10.0.0.12\Master /user:administrator password"
When prompted, press Y
Jared
CE - Microsoft
July 25, 2012 at 2:59 pm
Why not just pull the filenames into a table and do a left join. 3.5 million rows is really not that much data. I can load a million rows into...
Jared
CE - Microsoft
July 25, 2012 at 2:56 pm
Not sure why you can't attach the file. either use the IFCode shorcut for img or just click on the "edit attachments" button on the lower right of your reply.
Jared
CE - Microsoft
July 25, 2012 at 11:34 am
So, you are talking about the arrows that show the direction of the connection?
Jared
CE - Microsoft
July 25, 2012 at 11:30 am
What version of SSMS are you on? I don't have either of those windows...
Jared
CE - Microsoft
July 25, 2012 at 11:24 am
Tobar (7/25/2012)
What I...
Jared
CE - Microsoft
July 25, 2012 at 10:54 am
Viewing 15 posts - 406 through 420 (of 2,647 total)