Viewing 15 posts - 2,371 through 2,385 (of 6,041 total)
I'm not sure that PowerShell standing alone will become popular amoung Linux and Mac users for their daily scripting needs, but what this will do is expand the portability and...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 22, 2016 at 5:59 am
My 12 year old daughter will probably be posting the same question here a decade from now.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 19, 2016 at 1:42 pm
Steve Jones - SSC Editor (8/19/2016)
Eric M Russell (8/19/2016)
- If deploying a DDL...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 19, 2016 at 1:13 pm
A lot of us here became DBAs back when there weren't a lot of books on the topic. I'd start by looking at the eBooks published by Redgate and Brent...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 19, 2016 at 9:41 am
So, in a smoke test what you should really be looking for is not functionality... but smoke.
- If deploying a DDL script, scroll through the output window and look...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 19, 2016 at 7:04 am
My understanding is that, at least by default, when given a VARCHAR(MAX) column, SQL Server will only store the data offrow, if the total data size for a row doesn't...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 18, 2016 at 9:18 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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. 🙂
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 16, 2016 at 9:18 am
Viewing 15 posts - 2,371 through 2,385 (of 6,041 total)