Viewing 15 posts - 4,876 through 4,890 (of 8,416 total)
Ok, so there's not too much to be done here since SSMS does not expose the connection string or pooling options directly.
I haven't found a satisfactory workaround, but you do...
March 25, 2010 at 7:22 am
The Dixie Flatline (3/25/2010)
Paul, please tell me you don't have all that committed to memory. 😉
Ha...no, not at all. I remember very few facts, since they do not...
March 25, 2010 at 7:12 am
The Dixie Flatline (3/25/2010)
Paul, thanks for the save. I wasn't even close to thinking about isolation levels last night.
It's a team effort, Bob. 🙂
March 25, 2010 at 7:00 am
Just for fun.
WITH [Recursive]
AS (
SELECT TOP (1)
...
March 25, 2010 at 6:57 am
Bhuvnesh (3/25/2010)
if you have index on date column then min(date) kills seek operation on it which might result in slownees of query.
What do you mean here? Having an index...
March 25, 2010 at 6:56 am
DROP TABLE #T1
GO
CREATE TABLE #T1
(
AssetID ...
March 25, 2010 at 6:39 am
CREATE TABLE #T1
(
AssetID INTEGER NOT...
March 25, 2010 at 6:22 am
karthikeyan-444867 (3/25/2010)
Actually the table has more than 100000 records. So if i execute query likeselect Assetid,min(date)
from t1
group by assetid
having min(date) <> inceptiondate
it is taking 1 minutes.
.Net SqlClient Data Provider: Msg...
March 25, 2010 at 6:16 am
Confused.
If you go to SQL Server Configuration Manager, and look under SQL Server Services, is the SQL Full-text Filter Daemon Launcher running or not? If you have more than...
March 25, 2010 at 6:03 am
Can you get an estimated plan, or does that appear to freeze as well?
It is possible that the plan is taking a long time to optimize and compile, or it...
March 25, 2010 at 5:55 am
Fishbarnriots (3/25/2010)
Why 100 connections, a developer is reviewing his stored procs and is opening lots of connections.
100 connections is the default limit for a connection pool - that's a general...
March 25, 2010 at 4:31 am
:blink: Query Analyzer? Not SQL Server Management Studio? :blink:
Also, are you saying that you are opening 100 separate connections to the server to edit 100 different stored procedures? ...
March 25, 2010 at 4:12 am
Hey Bob and Eric,
I have no idea what is causing the duplicate insertions in the first place, but I do know that the trigger code is not sufficient to prevent...
March 25, 2010 at 3:56 am
Nugby (3/24/2010)
...I'd get nothing back despite there being a potential match for the 21st.
Ah, I see! Thanks for clarifying that. Just for completeness, all we need do is...
March 25, 2010 at 12:14 am
Viewing 15 posts - 4,876 through 4,890 (of 8,416 total)