Viewing 15 posts - 15,376 through 15,390 (of 22,211 total)
Notice how both rows have the same index_id. There's only one index there. A row is returned for each level that the index has in the B-Tree. Here's an MSDN...
April 23, 2010 at 7:36 am
Paul White NZ (4/23/2010)
Grant Fritchey (4/23/2010)
INSERT INTO dbo.x (x.nodatetime)I never knew you could specify a table alias (x) in the INSERT column list...how interesting.
Yeah, I didn't either. It was a...
April 23, 2010 at 7:15 am
What does the execution plan look like?
April 23, 2010 at 7:12 am
That's not a standard TsQL function, so you must have written it. Without the code, it's hard to know what's happenning. If you post the code for the function, you...
April 23, 2010 at 7:11 am
It sounds like you must have the trace events set up wrong.
BTW, you shouldn't run Profiler directly against production systems, especially if it's a system that is already experiencing performance...
April 23, 2010 at 7:09 am
Of course it's going to show a connection problem. You can't connect users when the license is exceeded.
But as Gail says, this won't cause performance issues on SQL Server.
April 23, 2010 at 7:07 am
The Dixie Flatline (4/23/2010)
What I can't understand is why some people think that the...
April 23, 2010 at 7:05 am
It's probably not an issue. Take a look at this Connect entry.
April 23, 2010 at 6:48 am
Dohsan (4/23/2010)
--Create Our Varchar Date Test Table
IF OBJECT_ID(N'Tempdb..#D', N'U') IS NOT NULL
DROP TABLE #D
GO
CREATE TABLE #D
(
IDINT IDENTITY(1,1),
DateVARCHAR(8)
PRIMARY KEY CLUSTERED (ID)
);
INSERT INTO #D (Date)
SELECT '20100422'...
April 23, 2010 at 6:42 am
Are you looking for something like this:
CREATE TABLE dbo.x
(nodatetime NVARCHAR(50));
INSERT INTO dbo.x
(x.nodatetime)
VALUES ('5/5/05')
,('4/4/04')
,('3/3/zz');
UPDATE dbo.x
SET x.nodatetime = NULL
WHERE ISDATE(x.nodatetime) = 0;
SELECT * FROM dbo.X;
April 23, 2010 at 6:41 am
trivedi.nikesh (4/23/2010)
I am heartily thankful to you. I will apply your suggested measures.
Please correct me if I am wrong
Reason behind Query is not performing good due to (in case...
April 23, 2010 at 6:19 am
ajrendall (4/23/2010)
Thanks for all the comments, much of what everyone has said has confirmed my suspicions. Basically I'm going to try a few tests with some large tables and see...
April 23, 2010 at 6:18 am
Then try to the SQL Agent. That will only run after SQL Server has completed it's startup.
April 23, 2010 at 5:41 am
Adam Machanic (4/22/2010)
CirquedeSQLeil (4/22/2010)I am really awe struck still at the comprehensive plagiarism on that site. Steve should also say something since SSC has the rights to some of...
April 23, 2010 at 5:29 am
CirquedeSQLeil (4/22/2010)
Jack Corbett (4/22/2010)
Paul White NZ (4/22/2010)
I just love the following article!http://www.hyderabadtechies.info/index.php/articles/39-articles/747-hyderabad-techies-article
Wish I had thought of it :doze:
The author 'kaustavm' is clearly one to watch 😉
I'm pretty sure this is...
April 23, 2010 at 5:24 am
Viewing 15 posts - 15,376 through 15,390 (of 22,211 total)