| Thread | Last Post | Replies |
|
| Statistics on locking during view execution? | 20 Nov 2008 16:30 GMT | - |
How can I test to see the difference in locking behavior before and after I add one or more WITH (NO LOCK) clauses to a view? I have tried the Show Execution Plan, Show Server Trace, and Show Client Statistics from the Query Analyzer but the results are not always consistent
|
| SQL Performance help | 20 Nov 2008 16:01 GMT | - |
Sample Table Schema Create table T1 ( DateColumn datetime,
|
| Extended Stored Procedures C++ | 20 Nov 2008 07:19 GMT | - |
We have many C++ Extended Stored Procedures (DLL) which is using some apis like srv_paramsetoutput etc. All of these apis are deprecated by MS and MS suggested to use CLR base implementation. Is it means that there will be no direct C++ support in coming version of SQL Server. ...
|
| include Readtext result in a query ? | 19 Nov 2008 20:01 GMT | - |
Is there a way to do a simple SELECT query and include the result of READTEXT as one of the fields (over 8000 chars) ? Thanks. Select field1, field2, Readtext result, field3 etc.......
|
| First item in DTS package will not execute | 19 Nov 2008 14:06 GMT | - |
I am trying to run a DTS package that I have run several times before without fail in SQL Server 2000. The package transfer data from another server (SQL Server 2005) to the local server. It populates one table, then another, etc. Lately the first item in the package
|
| Report Subscription | 19 Nov 2008 09:44 GMT | - |
Whenever I deploy a new rdl file to reporting services. My subscriptions are deleted from the report. Is there any way to backup the subscriptions
|
| Meet Singles From All Over The World .. FOR FREE !! | 18 Nov 2008 21:04 GMT | - |
Meet Singles In Your Area Arabs, American, Russian Singles From All Over The World Waiting For You At Frinzo
|
| Enable Data Access for local server | 18 Nov 2008 04:20 GMT | - |
It was my requirement to be able to use the local server in OpenQuery () function, as a linked server. So to test I did a: Exec sp_serveroption @server = '<local instance name>',@optname =
|
| Help with CTE | 17 Nov 2008 21:53 GMT | - |
This is my procedure: PROCEDURE [dbo].[usp_UpdateComments] (@xmlstring TEXT) AS BEGIN
|
| billiger strom und gas,stromanbieter wechseln nachtstrom,strom und gas wechsel,stromanbieter wechseln,guenstiger stromanbieter, | 16 Nov 2008 07:58 GMT | - |
billiger strom und gas,stromanbieter wechseln nachtstrom,strom und gas wechsel,stromanbieter wechseln,guenstiger stromanbieter, + +
|
| onewaylinkexchange.net / linkshighway.net is a fraud site | 15 Nov 2008 11:10 GMT | - |
I paid $10 for SEO link popularity traffic to the onewaylinkexchange.net, but they didn't do any link building. But they are charging $10 from my account monthly.
|
| Christmas Lights Installation Los Angeles, Beverly Hills, Santa Monica, Culver City, Marina Del Rey, Calabasas, Agoura Hills Thousand Oaks Holiday Lights Installation 1-310-925-1720 | 15 Nov 2008 02:31 GMT | - |
Christmas Lights Installation Los Angeles, Beverly Hills, Santa Monica, Culver City, Marina Del Rey, Calabasas, Agoura Hills Thousand Oaks Holiday Lights Installation 1-310-925-1720 http://christmaslightinginstall.blogspot.com/
|
| Chinese antique | 15 Nov 2008 02:09 GMT | - |
Chinese antique world first, the antique chinaware series please watch! Entire fidelity 100% Antique (1912-1949) Republic of China porcelain teapot 888 chinawares 400 please watching!
|
| Database Mail Step by Step help | 14 Nov 2008 16:21 GMT | - |
I am really not clear about how to setup database mail to send mail. Help file instructions is confused me more. -Do I need a valid mail server for this to work? (for instance we are using Exchange Server)
|
| SQL Server Enterprise Manager Shortcuts | 14 Nov 2008 15:21 GMT | - |
I'm looking for a shortcut to "add tables". Any other shortcuts for coomonly used functions would also be most welcome. Thanks
|