Viewing 15 posts - 30,166 through 30,180 (of 39,763 total)
The main risks are that someone can access resources outside SQL Server using a shell and could potentially damage the server. For bcp out, I don't know of another way....
December 23, 2007 at 9:19 am
There are ways to query an hierarchy and they get easier all the time, but if you know there are up to 3 levels, I'd build 3 tables, linking each...
December 22, 2007 at 3:19 pm
If you installed express, by default it doesn't take remote connections, only local ones. Might not be listening on a TCP port. Check the SQL error log to see if...
December 22, 2007 at 3:16 pm
insert x
select case when count(a) > 1 then 'All' else 'group' end 'firstcol'
, secondcol
...
from table
December 22, 2007 at 3:13 pm
Two ways,
One is to create a link table, has EmpID and SupervisorID, along with dates that correspond to the timeframes. For current assignments, leave the end date open and handle...
December 22, 2007 at 3:12 pm
First, please post this in a forum that makes sense for your post. You titled it SQL Server Express, so perhaps that forum.
Second, how are the data feeds coming? If...
December 22, 2007 at 3:09 pm
Thanks for the suggestions and I'll second the Stephanie Plum series mentioned above. They're hilarious, even laugh out loud in places.
I actually watched some of Night at the Museum today...
December 21, 2007 at 4:58 pm
Thanks and feel free to submit this as a script. We can get it out in the newsletter then.
December 21, 2007 at 4:56 pm
I had a 700GB database and it ran fairly well, but we had 5 or 6 filegroups, mulitple arrays and we had to be careful with maintenance. And we...
December 21, 2007 at 4:55 pm
Very strange. could be fragmentation.
How much data is in the table?
December 21, 2007 at 11:34 am
Troy,
I sympathize and I'd really recommend looking at 2005, even in 8.0 mode. The architectural enhancements will help with the load, especially if you can move to 64-bit.
That aside, a...
December 21, 2007 at 11:33 am
Be sure you're not one of the connections. Don't open a query window to that database, have one to master instead.
December 21, 2007 at 10:32 am
SSMS should do fine.
If this is only a SQL server, then I would probably set Min and Max to the same value. My impression for 64bit is that you would...
December 21, 2007 at 10:30 am
SQL_oracle has my caveats for network backups. Don't do it.
If you have bandwidth issues, then you're somewhat stuck as the bandwidth is required to do the backups.
What I'd recommend is...
December 20, 2007 at 3:04 pm
Did you attach the master database?
might have a naming conflict.
December 20, 2007 at 2:51 pm
Viewing 15 posts - 30,166 through 30,180 (of 39,763 total)