an interesting idea; i've got databases that have a lat/longitude for each county, so you could calculate where nearby counties are < 40 miles or something; but that's not what...

to get the fk constraints related to a specific table, use the proc sp_fkeys:

use pubs

sp_fkeys titles

results:

well my dev machine is just that...development, sample data, and if i take the service down to defrag, there's no real impact. , so i have a scheduled task of...

sounds like the application needs to be tweaked so that the name/connections to the server are parameterized and placed in an ini file, instead of hardcoded. an app should NOT...

you have to open a port in your firewall to allow your sql server to be visible to an outside IP address; further, if you are going to do this,...

if the file is in use, contig will skip the file, so yuo'd have to stop the server to defrag the mdf/ldf files;

i have it scheduled on my dev machine...

granting someone the role ddl_admin allows them to create procedures i believe, and by default anything they create they can execute.

here's my suggestions, but by no means do i purport to be the ultimate guru of query tuning;

#Source D and #Calculator_Table C are temp tables,make sure you put indexes...

to expand on what SQLZ said, with an ugly example:

do this on test copies until you are sure:

--identify the missing records, change the tablenames and dbnames to what is appropriate

installing SQL Server on a non-Server operating system automatically dummies itself down to MSDE; no need to download a dedicated executable. are you getting the dialog where you can install...

SQL Server Express/MSDE has a limit to the number of concurrent queries,

it's designed so a developer can test with the same codebase, but not with the same workload as...

i would have thought that differences in collation are what is breaking your comparisons.....but if all the columns are the same collation as the database, i would think that that...

our shop thinks of DBA's as two different categories....there's development DBA's, which only need access to the databases in order to create schemas, write procs,review other developers code, etc.. That role...

when you changed your database collation, did you change all the existing columns too?

a temp solution would be like this:

select * from gmact where actnbr like '120%' collate Sql_Latin1_General_CP1253_greek_CI_AS

a permenant...

in order to do that, the account used to run SQL server would need to have network rights...so instead of the default of running as system, it would need to...