Viewing 15 posts - 34,441 through 34,455 (of 39,726 total)
It's possible. We'll see what the demand is and what kind of deal we can work with a printer.
October 25, 2004 at 11:47 am
October 22, 2004 at 11:08 am
Task view in EM should give you table size. sp_help gives all columns. For varchar, select avg(len(col)) from the table.
October 22, 2004 at 11:04 am
There are reviews of Red Gate and Apex on this site:
http://www.sqlservercentral.com/columnists/awarren/sqlcomparereview.asp
http://www.sqlservercentral.com/columnists/chedgate/reviewofsqldiffbylockwood.asp
October 22, 2004 at 11:02 am
You can use VBScript and DMO to accomplish this:
October 22, 2004 at 11:02 am
Thanks, if you click the problem report, there is a form.
I just clicked "search" and entered "Rights" and click scripts and it worked.
October 22, 2004 at 11:00 am
This was a submitted question and I apologize about the right paren in #2 being so far to the right. HOWEVER, it is there.
It is something of a trick question,...
October 22, 2004 at 10:05 am
The explanation was incorrect and I had assumed this to be some undocumented feature. However as pointed out, "middle" acts as an alias. There is no middle join, however those...
October 21, 2004 at 3:45 pm
Do you know the selectivity of the various fields? If some are more selective, i.e., a query will return very few rows, then these are great candidates for the first...
October 19, 2004 at 12:27 pm
If the drive structure is the same, restore master and msdb after you've installed QSL on the new machine. If not, you need to backup all your DTS packages manually....
October 19, 2004 at 12:19 pm
October 19, 2004 at 12:18 pm
dtsrun will execute procedures. You will need to redistribute some DLLs for this.
October 19, 2004 at 12:17 pm
Should be in the cube poroperties or definition.
October 19, 2004 at 12:16 pm
I'd dig into the data. If it's returning things you don't expect, I usually look for data problems.
October 19, 2004 at 12:14 pm
Viewing 15 posts - 34,441 through 34,455 (of 39,726 total)