meta user
network profile
| bio | website | |
|---|---|---|
| location | The Wild, Wild West | |
| age | ||
| visits | member for | 1 year, 6 months |
| seen | 10 mins ago | |
| stats | profile views | 300 |
Most days I feel like I'm in over my head.
Some days I actually am.
But every day, I feel like MacGyver.
|
20h |
awarded | Constituent |
|
May 17 |
comment |
Cannot connect to MS SQL 2008 R2 by DBVisualizer. “Native SSPI library not loaded” error @BozoJoe nonetheless, it'd probably still be better for OP to contact DBVisualizer support. |
|
May 16 |
comment |
Performance Hit when upgrading to Oracle 11gr2 The question was closed because it was difficult to know what was going on and the OP either wasn't able or willing to provide potential answerers with the information that they needed. I hope you are able to get resolution on this but in order to do so, you may be asked for more information. |
|
May 16 |
revised |
Performance Hit when upgrading to Oracle 11gr2 removed p&v |
|
May 15 |
reviewed | No Action Needed Oracle UPDATE followed by SELECT in LinqPad |
|
May 15 |
reviewed | Approve suggested edit on Oracle UPDATE followed by SELECT in LinqPad |
|
May 14 |
comment |
Remote connection to PostgresSQL in Windows 2008 Server is prompting the error below also, do you have the windows firewall off? if it's on, is it configured to allow connections to the db server? |
|
May 14 |
comment |
Remote connection to PostgresSQL in Windows 2008 Server is prompting the error below nice. connecting with the postgres user. |
|
May 14 |
comment |
Where and how to store my weird datamart Hi there. You may want to merge your accounts. |
|
May 14 |
reviewed | Approve suggested edit on Where and how to store my weird datamart |
|
May 14 |
comment |
@JackDouglas I believe you mean "more stricter." |
|
May 13 |
awarded | Caucus |
|
May 12 |
comment |
Disk space full but logical space available in database Some good points in there. I'd be even more conservative recommendation for shrinking files. Namely: don't do it unless it's an emergency stopgap maneuver |
|
May 10 |
reviewed | Approve suggested edit on Real-time merge of two databases on different servers |
|
May 9 |
revised |
If I fail over one database, do the others that share the same mirror endpoint fail over as well? deleted 81 characters in body |
|
May 8 |
comment |
General tool to load dump files an alternative option for SQL Server would be to create a linked server. another alternative would be an ETL tool like Pentaho's Kettle product to move data between servers. |
|
May 7 |
awarded | Nice Answer |
|
May 7 |
comment |
Range query from month and year If the data type is integer, why not query it like it's and integer? |
|
May 7 |
comment |
Cannot rebuild index, but there's no reason why not? Also also, if I understand you correctly, when you run that query by Aaron, I'd expect you to not get any results because you're necessarily eliminating anything with the offending column type, right? |
|
May 7 |
comment |
Cannot rebuild index, but there's no reason why not? Also, please post the index definition |
