Viewing 15 posts - 5,161 through 5,175 (of 7,505 total)
did you enable "open rowset" on both instances ?
March 3, 2008 at 3:24 am
Since you need it realtime, your best option may be to define a linked server for the mysql server.
Check BOL.
March 2, 2008 at 8:15 am
You may want to check database triggers.
At SSC you can find examples and some articles regarding db audit, ...
e.g. http://www.sqlservercentral.com/articles/Auditing/62126/
March 2, 2008 at 8:13 am
just a short list:
- Gut feeling is not to install any datafiles in program file folders
- stay away from the boot drive or paging file drive with any datafiles
- What's...
February 29, 2008 at 8:15 am
in many cases the [not] exists with a correlated query will outperform a
left join with the where rightpart-table-column is null because
a [not] exists is performed using the (fast)...
February 28, 2008 at 9:21 am
no.
If you install a default instance, its name will be the servername
(servername\mssqlserver)
You can install a named instance without having a default instance.
February 27, 2008 at 1:55 pm
BOL states:
Scanning Modes
The mode in which the function is executed determines the level of scanning performed to obtain the statistical data that is used by the function. mode is specified...
February 27, 2008 at 1:31 am
- Can you post the ddl (sql2000 and sql2005) ? (tables/indexes/views)
- What's the reason the result sets are different ?
- Can you rewrite the query to a :
SELECT HWID1, HWID2,...
February 26, 2008 at 5:01 am
In that case, no doubt about it. use the guidance Vijaya Krishna has given.
And as said, restrict it's values with a constraint !
February 24, 2008 at 11:56 pm
I'd go with Jeff's reply !
Also make sure the sqlserver service account has the needed rights to
the new drives and folders !
February 24, 2008 at 1:58 pm
Many developers use nulls because the don't know what data is needed.
The simple question "does it matter if there are spaces or a zero if you didn't get the value...
February 24, 2008 at 1:55 pm
- did you check with sql2005 upgrade advisor ?
Should be your starting point for any preparation towards SQL2005.
- In BI-dev studio (vs2005) if you create a new bi-integration server project,
there...
February 24, 2008 at 1:49 pm
percentages, seems you're going to calculate with them, so _must_ be a numerical datatype.
I would store it as decimal (3,2). This way you can avoid the division by 100 .
If...
February 24, 2008 at 1:19 pm
did you move database files ?
February 24, 2008 at 10:30 am
If you don't specify fillfactor, sqlserver just rebuilds using the formar fillfacor.
To view the fill factor value of indexes, use the sys.indexes catalog view.
February 24, 2008 at 10:26 am
Viewing 15 posts - 5,161 through 5,175 (of 7,505 total)