Viewing 15 posts - 886 through 900 (of 4,272 total)
Are there any other versions of SQL installed on this machine? I've seen a similar error when trying to connect to older versions from newer versions, like using SQL...
October 24, 2011 at 2:27 pm
I guess I see it differently Jeff. I certainly agree SQL injection is not acceptable but I am opposed to having xp_cmdshell enabled without a really good reason. ...
October 24, 2011 at 2:23 pm
I am. Once the package is running SET values and configurations are done.
CEWII
October 24, 2011 at 10:11 am
Yes you can but what I am unsure about is order of precedence. If you happen to have the same variable in the config data will it overwrite the...
October 24, 2011 at 9:16 am
While the data may need to be retained for 7 years there is no reason it needs to be retained in that table.. I would consider archiving the data.
CEWII
October 22, 2011 at 9:53 am
While I don't have any experience with the HA side of the StarWind product I would be worried about the loss of data at the failover to the other node....
October 22, 2011 at 8:02 am
Views are kind of like stored queries they themselves will not perform better than the same query executed outside the view. When SQL uses a view it does a...
October 21, 2011 at 3:53 pm
Agree with the other posts, I have seen and run tlog backups while the full is running, as a matter of fact one of my REALLY large databases could hardly...
October 21, 2011 at 3:21 pm
isuckatsql (10/21/2011)
I changed the Regex and now it processes 100k records in 3 minutes 🙂
Even that seems slow, I moved 11M records from one table to another on my laptop...
October 21, 2011 at 2:58 pm
isuckatsql (10/21/2011)
yes RAID1, i have more drives on order, and will move the data to a RAID10.
Really my question was hardware vs. software RAID.
CEWII
October 21, 2011 at 2:51 pm
How about APP or COMMON or Consolidated.. Without know anything its a shot in the dark..
CEWII
October 21, 2011 at 12:09 pm
Revenant (10/21/2011)
Elliott Whitlow (10/21/2011)
October 21, 2011 at 12:01 pm
I believe you could certainly run a server side trace for this but I am wondering why you are so concerned about these events.
How are you using the data and...
October 21, 2011 at 11:45 am
My initial feeling is that you have a bottleneck on the IO side. your processors and RAM seem fine but the config for your disks is probably the issue....
October 21, 2011 at 11:41 am
JamesMorrison (10/21/2011)
Elliott Whitlow (10/21/2011)
So your director falls into the "good friend" exception I listed. Even the I would still tread lightly, I might make it a private "off the...
October 21, 2011 at 11:35 am
Viewing 15 posts - 886 through 900 (of 4,272 total)