w*******e
发帖数: 1622 | 1 First, mirroring is NOT a replication, which means you can NOT use LOG
READER here.
Second, BOL is your best friend. (Or, like BEIJING, she uses GOOGLE....
hehehe...)
reader? |
|
|
j*****n
发帖数: 1781 | 3 you can put it into your SP.
from BOL:
SET ANSI_WARNINGS OFF
Requires membership in the public role. |
|
j*****n
发帖数: 1781 | 4 check "GROUPING function" in BOL see if it can work in your case.
sorry, no time to think it in deep yet... |
|
j*****n
发帖数: 1781 | 5 use ESTIMATEONLY to see how big the size of tempdb is needed.
consider increasing space of the tempdb when possible;
otherwise consider separate checks instead of whole. such as NOINDEX,
PHYSICAL_ONLY, DATA_PURITY. conduct BOL for more information. |
|
j*****n
发帖数: 1781 | 6 It depends what's your major concern that you want to run this CHECKDB
command. Can you describe in more detail?
For example, if the major concern is about the consistency of disk space
allocation structures, actually you may think only use the DBCC CHECKALLOC
instead.
Again, BOL is the best resource for reference. |
|
y****9
发帖数: 144 | 7 I don't think this is a valid explanation, bcoz varchar(800) won't use 10
times more storage than varchar(80). Based on BOL,
varchar [ ( n | max ) ]
Variable-length, non-Unicode character data. n can be a value from 1 through
8,000. max indicates that the maximum storage size is 2^31-1 bytes. The
storage size is the actual length of data entered + 2 bytes. The data
entered can be 0 characters in length. The ISO synonyms for varchar are char
varying or character varying.
So if I know my data will... 阅读全帖 |
|
i****a
发帖数: 36252 | 8 Do you see any problem with set rowcount?
BOL says:
Important:
Using SET ROWCOUNT will not affect DELETE, INSERT, and UPDATE statements in
the next release of SQL Server. Avoid using SET ROWCOUNT with DELETE, INSERT
, and UPDATE statements in new development work, and plan to modify
applications that currently use it. We recommend that DELETE, INSERT, and
UPDATE statements that currently are using SET ROWCOUNT be rewritten to use
TOP.
As I understand it should be ok because the select statemen... 阅读全帖 |
|
z***y
发帖数: 7151 | 9 You have SQL SERVER 2008 R2 which has been short of memory. Now you had
added memory and need to monitor to make sure SQL SERVER has enough memory,
which options are needed (Two options are needed):
a. run dbcc memorystatus
b. Check SQL Server Buffer Manager: Checkpoint Pages/Sec
c. Chck SQL Server Memory Manager: Target Server Memory
d. SQL Server Buffer Manager: Page Life Expectancy
e. run select * from sys.dm_os_wait_stats order by wait_time_ms desc;
答错不丢人。 要求不google， 五分钟作答。 第一个答对并且有具体说明的， 给1... 阅读全帖 |
|
b********9
发帖数: 159 | 10 lol...lz please check bol, or go to a class. good luck! :-) |
|
|
w*******y
发帖数: 60932 | 12 $2 for a 16oz. Coldbuster smoothie
$1 for Steel Cut Oatmeal
$1 for a 12 oz. New Probiotic Fruit & Yogurt Blend
Coupons valid from 1/10 to 1/19
Link:
http://www.jambajuice.com/bol-coupon
|
|
A********o
发帖数: 13968 | 13 Arsenal ARS
Aston Villa AST
Blackburn BLA
Bolton BOL
Charlton CHA
Chelsea CHE
Everton EVE
Fulham FUL
Liverpool LIV
Man City MAC
Man Utd MAN
Middlesbro' MID
Newcastle NUF
Portsmouth POR
Reading RED
Sheff Utd SHE
Tottenham TOT
Watford WAT
West Ham WHU
Wigan Athletic WIG |
|
p****r
发帖数: 4348 | 14 越位 瓦多 塔来
斯坦 附加 曼尼 怕死托雷
锡娃 炉小 不理托斯
阿妹
S: Bol
F: 1 |
|
a*****s
发帖数: 4609 | 15 来自主题: _FantaSoccer版 - I 作业 索伦蒂诺
格罗索，鲁西奥，斯尔维斯特里
瓶急，多尼，斯奈德，德罗洗
克鲁斯，吉拉蒂诺，爬起你
G:2
S:BOL |
|
a*******i
发帖数: 11664 | 16 五强至少有钱拿了：
mancity 1
milanbear 1
MLPG 2
WindyHan 1
zhizunbao 1
当前战况及每轮pick：
http://spreadsheets.google.com/pub?key=tNZs93yE6gufaT_HfL-achg&output=html
下轮对阵：
Sun, Nov 8 CAG versus SAM
Sun, Nov 8 BOL versus PAL
Sun, Nov 8 BAR versus LIV
Sun, Nov 8 ATA versus JUV
Sun, Nov 8 CAT versus NAP
Sun, Nov 8 GEN versus SIE
Sun, Nov 8 UDI versus FIO
Sun, Nov 8 PAR versus CHI
Sun, Nov 8 LAZ versus MIL
Sun, Nov 8 INT versus ROM
默认：
inter > juv> samp > ac >fio > nap > |
|
