Viewing 15 posts - 5,116 through 5,130 (of 5,685 total)
SQL33 (11/2/2010)
November 2, 2010 at 2:53 pm
I must say I'm suddenly quite happy to be living in AZ. We don't mess with that old farmer's wit of a time system. Savings time... bah! ...
November 2, 2010 at 2:45 pm
OS is reading and writing to the drive, SQL is reading/writing to its Data file, and SQL is reading/writing to its Log file.
Add one more, the tempdb is churning on...
November 2, 2010 at 2:42 pm
What kind of CPU pressure is on your production box? It's a standard signal wait, well, for the class of them. I found this query to help measure...
November 2, 2010 at 1:53 pm
mymail.default (11/2/2010)
Craig,I made the SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
and unfortunately it did not improve things at all...
Strange! There should be something else causing the issue.
Rats.
One important thing I...
November 2, 2010 at 1:48 pm
Alright, end to end code. SQL33, please note, I have no idea what a number of these fields mean, and if I got your spacing off, there should be...
November 2, 2010 at 1:41 pm
GilaMonster (11/2/2010)
Correct. Index names only have to be unique within a table, while constraint names have to be unique in the DB
I so rarely create constraints I'd forgotten that. ...
November 2, 2010 at 12:37 pm
Ninja, the CREATE INDEX #idx_1 ...
also works as CREATE INDEX idx_1...
Don't need the # for the index name there. Just fyi. Works either way.
November 2, 2010 at 11:58 am
Goldie Lesser (11/2/2010)
Ninja's_RGR'us (11/2/2010)
I do that in prod no problem. Can you post the create table and index scripts you are using?
All 3 of these fail:
CREATE TABLE #Table1
(
...
November 2, 2010 at 11:56 am
Ninja's_RGR'us (11/2/2010)
Even if it makes no difference here, it should read : IF Object_id('tempdb..#tmp') IS NOT NULLWith tempdb.. missing you'll never have a hit on that id.
Hmmmm....
CREATE TABLE #tmp (tID...
November 2, 2010 at 11:53 am
Hm, the only solutions I'd have for you with this puzzle would be in T-SQL code, not at the reporting layer.
If you really wanted a date average, you could take...
November 2, 2010 at 11:46 am
Just to make sure they didn't change something on me in 2k8...
From: http://msdn.microsoft.com/en-us/library/ms188783.aspx
index_name
Is the name of the index. Index names must be unique within a table or view but...
November 2, 2010 at 11:42 am
Brandie Tarvin (11/2/2010)
GilaMonster (11/2/2010)
WayneS (11/2/2010)
Date field stored as varchar(8000) - what kinds of problems do you see coming up from this OP?
8000 characters for a date? I could store an...
November 2, 2010 at 11:38 am
Yeah, even this doesn't work:
CREATE TABLE #tmp (tID INT);
IF Object_id('#tmp') IS NOT NULL
BEGIN
DROP TABLE #tmp
END;
IF Object_id('#tmp') IS NULL
BEGIN
CREATE TABLE #tmp(tID INT, tTxt VARCHAR(50))
END;
So, I'm going to go with I had...
November 2, 2010 at 11:35 am
Naidu,
Note that it's all on the #tmp table, which is a temporary build in the tempdb, not a permanent structure. You should have the rights to run both that...
November 2, 2010 at 10:53 am
Viewing 15 posts - 5,116 through 5,130 (of 5,685 total)