w*******e
发帖数: 1622 | 1 这中文， 你要不说我都不知什么是“企业管理器"
在2K5里是SQL Server Management Studio了, 不叫Enterprise Manager了 |
|
M*****r
发帖数: 1536 | 2 I searched a lot, and the only solution I can find is to:
1. Create cluster index on the new filegroup
2. Delete the cluster index
Is there any other way?
In SQL Server 2K, it can be done in Enterprise manager, but I cannot find
the funcationality now...
Thx! |
|
w*******e
发帖数: 1622 | 3 In SQL2K, 也不能只移one table to a specific filegroup吧
当然在你create table时可以指定一个file group |
|
S***k
发帖数: 370 | 4 As far as I know, it is the only way without any trouble to move an existing
table to a new file group. |
|
n*******a
发帖数: 27 | 5 不行的好象，不能指定FILEGROUP,存储是文件系统管理的,
不知道为什么你CARE ABOUT THAT. |
|
|
|
j*****n
发帖数: 1781 | 8 嗯，这个比较麻烦，得看情况：
多少个 cpu,
多少 ram,
磁盘阵列/SAN 的连接情况，有几个 physical I/O path,
SQL Server 2k5 EE 的话还要考虑是否作 table partitioning,
32 bit 得考虑 AWE (Allocation Windowing Extensions)
数据库是用作 OLTP/OLAP,
OLTP 的话还得小心 clustered index,
建议先开一个 perfmon 看看, 找到bottle neck 再说其他。 |
|
j*****n
发帖数: 1781 | 9 PARTITION BY ?
never try it with T-SQL, it might be new in 2k5...
en, I am somewhat out of date...
your DISTINCT is the performance killer, definitely no necessary in your
case. |
|
j*****n
发帖数: 1781 | 10 yeap, just checked Books Online, it is new in 2k5 :)
DB2 has similar function too.
maybe it is copied from Oracle, just like the table partitioning, hehe |
|
j*****n
发帖数: 1781 | 11 damn, this is another new function in 2k5....
sounds like an Oracle person can easily take over my job... //sigh |
|
j*****n
发帖数: 1781 | 12 even you can not import/export data via express version.
2k5 needs SSIS to do that... |
|
j*****n
发帖数: 1781 | 13 MS SQL 2K5 Evaluate Edition, free for 180 days, has full functionality. |
|
j*****n
发帖数: 1781 | 14 in addition, there is NO WAY to run DTS under 2k5 64bit, no run-time env
support for it. |
|
b********r
发帖数: 59 | 15 Sorry, it works only in SQL Server.
For SQL Server 2k5 or 2k8, you can use sqlcmd to replace osql |
|
w*******e
发帖数: 1622 | 16 在2K5里, maintenance plan就是用SSIS的 |
|
p********l
发帖数: 279 | 17 Oops, I forgot this is for SQL 2005. There are a lot of differece between 2k
and 2k5. |
|
j*****n
发帖数: 1781 | 18 2k5 only:
SELECT DISTINCT name, type, type_desc
FROM sys.objects
WHERE object_id IN
(SELECT object_id FROM sys.sql_dependencies A
JOIN sys.syscolumns B
ON A.object_id = B.object_id AND A.column_id = B.column_id
WHERE B.object_id = OBJECT_ID(N'tableTT')
AND B.name = N'colBB'
) |
|
j*****n
发帖数: 1781 | 19 sure you can use this one...
however, system tables will not available for later SQL server versions.
This is good for 2000, in 2k5, the speed is low. |
|
|
j*****n
发帖数: 1781 | 21 You'd thank for that you are using 2k8... 2k5 got even more night mare...
hehe |
|
j*****n
发帖数: 1781 | 22 hehe, 2k5 new feature....
OUTPUT clause
delete from Table_1
OUTPUT DELETED.*
where Year = 2008 |
|
j*****n
发帖数: 1781 | 23 don't think so... try to download full functional evaluate version for 2k8.
2k5 has 180 days, good enough. |
|
j*****n
发帖数: 1781 | 24 It is a good solution.
btw, try CTE with ROW_NUMBER() in 2k5 and 2k8. Same way to solve problem but
looks fancier. |
|
j*****n
发帖数: 1781 | 25 Based on SQLSRV 2k5 BOL:
A full database backup backs up the whole database. This includes part of
the transaction log so that the full database backup can be recovered. Full
database backups represent the database at the time the backup finished.
Therefore, I believe it is Point B.
done |
|
j*****n
发帖数: 1781 | 26
ROW_NUMBER
~~~ I was just want to say: ask Bejing for answer, hehe...
btw, it is good for MS SQL server 2k5 and above version, otherwise you got
to use TOP 1 option. |
|
|
c******e
发帖数: 558 | 28 最近数据库从2k5升级到2k8，但是升级后不能设置witness，总是报错说不能连接
witness server的端点，不能alter databae。在witness server上看到endpoint是0.0
.0.5022，这是啥问题？谢谢! |
|
j*****n
发帖数: 1781 | 29 I bet you are using SSMS in 2k5, right? If you happen to use SSMS in 2k8, it
does provide the functionality you need. Just like what you are using the
VS. |
|
i****a
发帖数: 36252 | 30 I am using 2k8 SSMS but the intellisense only works when connecting to 2k8
servers. 99% of our servers are on 2k5.
also, there is no code formatting in SSMS. manually making sure code is in
standard formatting can be tiring.
2k8, it
the |
|
j*****n
发帖数: 1781 | 31 MSSQL 2k5
Here is a table with about 400 columns, billions of rows; we have a view
does this:
SELECT .....,
CAST (col_n AS VARCHAR(11)) AS col_n, -- col_n is MONEY data type in the
table
...
FROM tbl
We have an SSIS ETL runs every day that pulling millions of rows based on
this view; it has been ran for couple years without problem.
Recently (started few weeks ago), we discovered that randomly this converted
col_n returns few 0's, no matter whatever the actual value is. say 20.12,
or -128.33... 阅读全帖 |
|
H**********k
发帖数: 224 | 32 似乎有编译器的问题
matlab win是msvc 2k5编译的
linux下面是gcc编译的
但是，matlab核心就是intel mkl啊，难不成
intel mkl本身在lin/win下面performance就差很多? |
|
|
D*****I
发帖数: 8268 | 34 开了OD，二档窜转速，比如3k,还是比1档2k5会感觉无力的啊 |
|
p*********e
发帖数: 32207 | 35 我以为楼主默认是速度一样的前提下开od转速更高...二档3k可比一档2k5车速快多啦 |
|
D*****I
发帖数: 8268 | 36 经常红线么？
2k5油里面添加剂都才进入状态呢
弄点used oil去lab做个分析吧 |
|
D*****I
发帖数: 8268 | 37 这个手应该可以感觉出来的吧，别蛮干就行了。。。
2k5-3k转换档的飘过。。。
". |
|
n**y
发帖数: 11447 | 38 找个实测图对比一下
我看到的dyno图328i扭矩到峰值也得2k5到3k转了 |
|
D*****I
发帖数: 8268 | 39 4k进2k5应该会降吧，反正你如果买菜开法就等呗，要激情就转速再上去咯 |
|
|
F**********y
发帖数: 10265 | 41 HSA好像要规定上限2K5了，医疗保险的钱和HSA不一样，这样还可以再多
但是在边缘上很不secure啊，比如有的人不想存满401K或者那年收入多了就不能了，总
之还是很麻烦，:S
头一 |
|
F**********y
发帖数: 10265 | 42 nod nod
不是说以后要规定HSA一年一家只能存2K5了么。。。。 |
|
|
|
