Viewing 15 posts - 2,371 through 2,385 (of 6,035 total)
You can use Project Parameters and Expressions to specify things like server names and network paths at runtime. The value of the parameter can be set from the job...
August 18, 2016 at 7:55 am
Government IT departments, at least at the state and federal level, are well funded, and IT platform tools they use are similar to what you would find in the corporate...
August 18, 2016 at 7:08 am
- Sometimes (usually not) an application will populate the Program property of the connection with something like the user's login name, so when qyerying the SQL Server connections DMV, examine...
August 18, 2016 at 6:52 am
The next stage is to allow text blobs to use temporal tables by introducing versioning and differencing. That would be an interesting hybrid technology!
When we talk about versioning and...
August 17, 2016 at 3:10 pm
I've survived many rounds of layoffs at several different corporations, so I've been fortunate in that regard. What I've noticed is that the guy with the jack-of-all-trades or internal consultant...
August 17, 2016 at 8:22 am
SSIS does a good job of manipulating rows and columns within buffers as it moves through the pipeline, but sometimes loading the data into target table as fast as possible...
August 17, 2016 at 7:50 am
Every IT organization I've ever worked for has had a Patient/Customer/Student search application similar to this, and optimizing this type of thing is a classic problem. My default advice is...
August 17, 2016 at 7:30 am
Hi Rod,
Google: filetype:xlsx new mexico counties population
http://www.census.gov/popest/data/intercensal/county/tables/CO-EST00INT-01/CO-EST00INT-01-35.xls
As for your network connectivity issues, please email help desk support. 🙂
August 16, 2016 at 9:56 am
The same goes for non-clustered indexes; in terms of query predicates, column position in an index matters.
August 16, 2016 at 9:18 am
To be sargable, the query would need to filter on the leading column in the index.
For example, assume we have CLUSTERED INDEX ( StoreID, TransactionID, ProductID ). A query WHERE...
August 16, 2016 at 9:16 am
Unless the log growth was the result of a one-off process and the disk space is shared by other databases, I don't see the point in shrinking. Maybe focus on...
August 16, 2016 at 9:01 am
Ed Wagner (8/16/2016)
Eric M Russell (8/16/2016)
Ed Wagner (8/16/2016)
Eric M Russell (8/16/2016)
August 16, 2016 at 8:57 am
Ed Wagner (8/16/2016)
Eric M Russell (8/16/2016)
August 16, 2016 at 8:47 am
It would be useful to have an experienced gray haired DBA who could offer technical assistance and architectural advice across any number of projects, more like an analyst role, wihout...
August 16, 2016 at 7:14 am
The engineering DNA of the SQL Server database engine is optimized for online transaction processing, not bulk loading or aggregation.
You may also want to consider BCP-ing the 600 GB...
August 16, 2016 at 7:03 am
Viewing 15 posts - 2,371 through 2,385 (of 6,035 total)