Viewing 15 posts - 47,716 through 47,730 (of 49,571 total)
A hypothetical index is created by the database tuning advisor as it's attempting to find the 'correct' indexes. It's dropped once the run is complete
From what I understand, they're indexes...
January 11, 2008 at 8:09 am
Control Server = sysadmin. They're the same
What default db is the login set to? Does the login have a mapped user in that db? Is the default db in restricted...
January 11, 2008 at 8:05 am
No.
Begin != Begin transaction
Begin...End are just used to group code together. eg
IF (condition)
Begin
Do lots of things
End
Unless you explicitly begin a transaction, SQL works in autocommit,...
January 11, 2008 at 7:39 am
No.
Despite its name, a timestamp is not related in any way to a datetime. It's a binary value that's unique in the database that increases whenever the row is...
January 11, 2008 at 4:23 am
No way that I know of (though I'm not a SSIS guru)
You can use profiler to capture the showplan xml event. That will get you the xml plan for each...
January 10, 2008 at 11:36 pm
webrunner (1/10/2008)
January 10, 2008 at 11:28 pm
I think it's a seperate download. Been a while since I played with Express.
As for the connections, not sure.
January 10, 2008 at 1:59 pm
Should do. It's easy to test. In one query window, run the begin tran and the delete but nothing else. In another window, try to select from the table. The...
January 10, 2008 at 1:54 pm
What profiler event is it appearing under?
SQL:Batch completed means it's an ad-hoc query, with the text been directly executed.
You can include the dbid and objectid columns in profiler. The first...
January 10, 2008 at 1:52 pm
I could be mistaken, but I believe you'll need to script the database on 2000, run the script on SQL 7, then bcp/DTS the data over.
Databases can be upgraded fairy...
January 10, 2008 at 1:50 pm
With reporting services all you'll need on the client PCs is a web browser.
A small word of warning. SQL express is the free, low end edition of SQL Server. It's...
January 10, 2008 at 1:43 pm
GilaMonster (1/10/2008)
Indeed there is.exec xp_msver 'ProcessorCount' -- There are a lot of other options on msver. Well worth a look.
Clarification: This will return the number of processors that SQL thinks...
January 10, 2008 at 1:40 pm
Since you're using SQL Express, and the db files are already in use by the sql service, you don't want to do the file-based connection.
You want to connect to a...
January 10, 2008 at 1:37 pm
Viewing 15 posts - 47,716 through 47,730 (of 49,571 total)