Viewing 15 posts - 47,701 through 47,715 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 11, 2008 at 4:23 am
Could you post your code please?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 11, 2008 at 3:53 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 10, 2008 at 11:36 pm
webrunner (1/10/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 10, 2008 at 1:37 pm
Jim Russell (1/10/2008)
I can't find it now, but I think that was documented somewhere in BOL, so I just sighed and took it as a given.
Is this what you're...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 10, 2008 at 1:23 pm
Could you post the VB code where you try to connect please?
Re Reporting services. You can create reports with parameters. Users can then enter values they like. Is very much...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 10, 2008 at 1:11 pm
And also you can only put a single index on a table var - the primary key. Not great if you would like an index on a non-unique column.
Rule of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 10, 2008 at 1:04 pm
TablockX isn't an an isolation level. It's a lock hint.
You should be able to just do the delete then the insert within the transaction. In the default isolation level, exclusive...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 10, 2008 at 1:00 pm
Viewing 15 posts - 47,701 through 47,715 (of 49,552 total)