Viewing 15 posts - 2,071 through 2,085 (of 5,103 total)
I am nothing but disgusted that M$ is doing such a poor Job!
I would have never expected that "we" are compiling those and M$ is simply playing catch up...
April 10, 2007 at 9:07 am
And the zaga continues. They posted that the membership scripting issue was "solved" on SP2 and guess what? When I checked my SP2 installation it still does not scripts built-in...
April 10, 2007 at 9:00 am
Sorry I just lost my post. Here are *my* reasons:
-If you shrink it all work performed by previous reindexing is spoiled( pages are moved in the file unless you use...
April 4, 2007 at 12:11 pm
I have seen this approach before and it *is* quite fast but when you try to make the returned values into readable format is when you get hit *hard* by...
April 2, 2007 at 9:12 am
As part o preparing a database for transactional replication it *is* MS advice to mark FKs, Triggers and Identity columns as NOT FOR REPLICATION *before* you create the publication. This...
March 28, 2007 at 9:01 am
I think the article was clear and very to the point but besides the advantages of using this technique the drawbacks should also be pointed out.
I have had memory...
March 27, 2007 at 8:16 am
The rights required are ddladmin, db_owner or sysadmin. If you are fine with granting ddladmin you will be fine. Other method is to use TRUNCATE TABLE (resets to...
March 23, 2007 at 4:23 pm
-- My Solution: Use an indexed view: (Borrowing Names from mkeast
)
CREATE TABLE dbo.NullPKTest
(
nid int PRIMARY KEY
, nulltest varchar(10) NULL...
March 23, 2007 at 4:17 pm
Hey I am here ... just kidding ![]()
There are *many* talented people around but "references" are the KEY. If you can get to them...
March 23, 2007 at 3:59 pm
If you SET the DB to read-only all locking mechanisms will be bypassed!
March 23, 2007 at 12:29 pm
Maybe I am confused but what is "real-time" about all this ?
It is a nice summary of nifty features on DTS the title is misleading though.
March 22, 2007 at 7:45 am
A 10GB data warehouse is small enough to follow the proposed procedure.
When your data warehouse reaches 200 to 500GB you will get into a TOTALLY different ball game.
Cheers,
March 19, 2007 at 2:11 pm
If you have Indexed views or Computed colums you need to have the correct "SET" environment:
set ansi_nulls on
set quoted_identifier on
set ansi_warnings on
set ansi_padding on
set arithabort on
set concat_null_yields_null on
set numeric_roundabort off
Cheers,
March 13, 2007 at 12:26 pm
You need the help of Two stored procedures:
use distribution
sp_help_agent_profile @agent_type = 2 --LogReader=2
go
sp_help_agent_parameter @profile_id = 3
go
On the above example I used sp_help_agent_profile to determine what is the default (currently running)...
March 13, 2007 at 12:16 pm
Viewing 15 posts - 2,071 through 2,085 (of 5,103 total)