This is a pretty straight-forward answer that can be found in Books Online under the Truncating and Rounding Results section of the [CAST and CONVERT][1] page: > When you convert character or binary > expressions (char, nchar, nvarchar, > varchar, ...

If one would follow the mantra that there are no stupid questions, then I would say there are no bad queries . . . just some that take a long time to answer and give some of us jobs :). So, is the first query bad? Eh - it depends. As the post by Na...

Assuming that we are limiting our discussion scope to local temporary tables and table variables, I will not comment on specifics of global temporary tables, table-valued parameters, or table expressions. These other temporary table derivatives would h...

Please forgive the informal nature of my response; my requirements for XML processing are usually self-inflicted (I designed it into the system for my own purposes) or are so minor that I have not invested as much time into investigating which might bes...

I am no expert on replication by any stretch of the imagination; however, a couple of things invariably push me toward the use of merge replication (between 2 given options): 1. First and foremost, updatable subscriptions on transactional replicatio...

The configuration given shows we're running a 32 bit version of MSSQL 2008 Enterprise edition on a 64 bit version Windows 2008 Server R2 or Windows 7. As such, there are a few possibilities depending upon system configuration: Conventional Memory ...

<p>I as well am unclear as to what you are after exactly.  However, based on the description and the title, I've come up with the following possiblity:</p> <pre class="brush:sql">use tempdb; go -- Table of sequences create table seqs ( ...

It occurs to me that the performance gap between ad hoc and parameterized queries is reciprocal; in other words, a performance gain or loss can be found when comparing one to the other in one scenario whereas the opposite occurs in another. Consider th...

So, in step with the answers already given, one could: 1. Create a standard subscription for each manager, passing their territory in as a variable (alteration to the report required). This approach may be tedious if there a...