Viewing 15 posts - 1,666 through 1,680 (of 7,502 total)
Books online (SQL2008R2) "Database Mirroring Overview" states:
Database Mirroring Support
Since SQL Server 2005 Service Pack 1 (SP1), database mirroring partners and witnesses have been supported by Standard and Enterprise Edition. But...
September 21, 2011 at 2:20 pm
SQL Kiwi (9/18/2011)
ALZDBA (9/18/2011)
probably about the only thing missing to get a meaningful result is the product indication:
The original specification calls for quantity, not total price (that's why I used...
September 18, 2011 at 11:47 pm
SQLRNNR (9/18/2011)
ALZDBA (9/18/2011)
Lynn Pettis (9/18/2011)
bitbucket-25253 (9/17/2011)
Ninja's_RGR'us (9/17/2011)
Now all I know about Oracle...
September 18, 2011 at 2:42 pm
probably about the only thing missing to get a meaningful result is the product indication:
SELECT ProductName, sum(SalePrice)
FROM Products p
INNER JOIN Sales s ON s.ProductID = p.ProductID
group by ProductName
order by...
September 18, 2011 at 2:38 pm
Keep in mind if that use is member of a user defined db role that has been added to the db_owner groupmembers, SSMS will show db_owner membership as well !
In...
September 18, 2011 at 3:16 am
Lynn Pettis (9/18/2011)
bitbucket-25253 (9/17/2011)
Ninja's_RGR'us (9/17/2011)
Now all I know about Oracle is how...
September 18, 2011 at 2:16 am
I wonder if SSC DBadmins have taken performance precautions for such atypical rare threads ?
Could this already mess up query plans or be of any other concern ?
September 18, 2011 at 2:01 am
Chapter 4: Summing and grouping page 36 topic A.2
September 17, 2011 at 3:10 pm
GSquared (9/16/2011)
GilaMonster (9/16/2011)
ALZDBA (9/16/2011)
Tom.Thomson (9/16/2011)
5) risks of using backup log to append a log backup to an existing file containing log backups instead of always creating a new...
September 16, 2011 at 11:28 pm
Tom.Thomson (9/16/2011)
5) risks of using backup log to append a log backup to an existing file containing log backups instead of always creating a new backup file for...
September 16, 2011 at 2:02 pm
GilaMonster (9/16/2011)
I suspect this got lost in all the 'helping Grant abuse SQL' posts...
Spot on ! Sorry for that ...
Another request:
I'm bunking tonight and starting the rewrite of my rather...
September 16, 2011 at 7:31 am
As proven more than once, we take it further than the end in The Thread :hehe::Wow:
September 16, 2011 at 6:56 am
shatrughna (9/16/2011)
Hi,You can do it by dynamic SQL statement.
Search Google for Dynamic SQL statement.
Thanks
Shatrughna
Indeed, if you don't care about security, plan-recompile, ....
September 16, 2011 at 6:52 am
Gianluca Sartori (9/16/2011)
...
Good catch, Gianluca !
That is indeed a risk to assess, and that didn't even cross my mind. :crazy:
As it appears, my test data hasn't been adequate...
September 16, 2011 at 6:48 am
You could setup a test and rebuild a partitioned tables partitioned index and see how locking behaves by e.g. sampling sp_lock or trace locking
September 16, 2011 at 4:19 am
Viewing 15 posts - 1,666 through 1,680 (of 7,502 total)