Viewing 15 posts - 241 through 255 (of 522 total)
Yes, I think so. I remember some xquery syntax was changed from beta to RTM
January 6, 2006 at 6:50 am
generally speaking, you should create indexes on FK columns, e.g. create an index on Emp_ID column in Table 2
January 5, 2006 at 1:17 pm
To declare default namespace, there is no "=" after namespace keyword. And there is a ";" after the namespace string. The following query works:
SELECT
TOP...
January 5, 2006 at 1:13 pm
This is the same behaviour as SQL 2000. The back up destination is a folder on the server machine.
January 3, 2006 at 7:14 am
I cannot find the option too. But you can change the generated create table script and add the PK or FK. The wizard will execute the code. This is really...
December 23, 2005 at 9:15 am
If you are importing multiple sheets from one xls file, it's better to define a linked server to the xls file. Then you can use the four part name to...
December 23, 2005 at 8:47 am
Page Faults/sec can be soft fault (the page is still in physical ram) or hard faults (page is in pagefile).
Page Reads/sec and
December 23, 2005 at 8:44 am
If your application calls stored procedures, you can temprorarily add "COMMIT" or "ROLLBACK" in the beginning of the called SP. Then you can changed the SP back.
December 23, 2005 at 8:15 am
You can backup the database to multiple devices like:
BACKUP DATABASE YourDBTO DISK='C:\backupfile1', DISK='C:\backupfile2',...
You can have at most 64 files.
December 23, 2005 at 8:11 am
From the error below, you reached the limit of the number of connections (you configured 4)
"Could not connect because the maximum number of '4' user connections has already been...
December 22, 2005 at 9:46 am
When you define the linked server, you can leave the login mapping blank, and select "Be made using the login's current security context"
If other users do not have permissions to...
December 20, 2005 at 9:04 am
There are lots of inforamtion about table partitioning. If your application just accesses the latest records (a few millions, right?), you need to find out the partition column (datetime column...
December 20, 2005 at 8:45 am
check this: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/a3d3c1a5-6ca0-465b-b1d4-f197dd2b682d.htm in bol
December 20, 2005 at 8:24 am
Since the date in the source table is in the specific format, you have to tell SQL sever when you convert it to datetime like this:
convert
December 20, 2005 at 8:12 am
Are you using rtm? according to bol, DROP_SERVER_ROLE_MEMBER is not a server scope ddl event/event group.
December 20, 2005 at 8:01 am
Viewing 15 posts - 241 through 255 (of 522 total)