Viewing 15 posts - 13,726 through 13,740 (of 26,484 total)
er.sivaganesh (3/16/2012)
no i don't nead join query
And more importantly, YOU DON'T NEED A CURSOR EITHER.
March 16, 2012 at 7:29 am
er.sivaganesh (3/16/2012)
iam just using that value one by one for searchinga name in a another table iam using like %+@value+%
I figured. ...
March 16, 2012 at 7:03 am
Why do you need to use a cursor? There is nothing in your post that indicates that one is needed.
I will be honest, if you really think you need...
March 16, 2012 at 6:55 am
The more you work with them the better. When it comes to indexes, just remember that the object_id is the table on which the index is created. To...
March 15, 2012 at 4:14 pm
bsdtux (3/15/2012)
Thanks. Sorry for asking probably what seems like a basic question. Again thanks for the correction to my query.
You'll have to pardon me, fighting with a couple of queries...
March 15, 2012 at 4:07 pm
bsdtux (3/15/2012)
That worked great. Thanks. So what would have caused the duplication of index record names and different fragmentation information?
Really? Look at each of the tables where I modified...
March 15, 2012 at 3:52 pm
Your join to sys.indexes is wrong. It should look like this:
SELECT
dbIndx.database_id,
dbIndx.object_id,
obj.name AS ,
...
March 15, 2012 at 3:32 pm
Antivirus software, other utility type software?
March 15, 2012 at 2:48 pm
Lowell (3/15/2012)
but the issue is, "you cannot tell the which is the "middle" name between "James Tiberius Kirk"...
March 15, 2012 at 2:30 pm
I see things in the code that may be forcing table scans. The use of NOT IN and <> in the WHERE clauses of a couple of the UNION...
March 15, 2012 at 2:18 pm
THANG HOANG (3/15/2012)
Both or our SQL 2005 and 2008 Enterprise Edition are 64bit.The one difference is SQL 2005 runs on Windows Server 2003,
and SQL 2008 runs on Windows Server 2008.
Doesn't...
March 15, 2012 at 2:13 pm
THANG HOANG (3/15/2012)
And I did rebuild the indexes...
March 15, 2012 at 2:09 pm
er.sivaganesh (3/15/2012)
iam not getting proper loop structure thats why i posted two three postand sorry for your inconvience
First, you probably don't need a loop...
March 15, 2012 at 2:05 pm
Thinking about it a bit more, the equality condition may have turned the LEFT OUTER JOIN into an INNER JOIN when done in the WHERE clause.
March 15, 2012 at 1:48 pm
Viewing 15 posts - 13,726 through 13,740 (of 26,484 total)