Viewing 15 posts - 316 through 330 (of 621 total)
Ok, I took the liberty of assuming the possibility of there being more than one row in your table is too great to ignore. I also took the liberty...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 12, 2009 at 9:08 am
WebTechie38 (5/12/2009)
I need to run this for 15 columns. Folks keep posting this same checksum example with one column.
Check out BOL for CHECKSUM, and it should make sense why...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 12, 2009 at 7:10 am
I can't see why Lowell's solution does not work, unless everyone, regardless of whether or not they have a photo present, exists in the table selling_photo.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 11, 2009 at 8:14 pm
There is probably a better way to do this, without using dynamic SQL, but here is one way to do it. You said your table has one long row....
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 11, 2009 at 12:52 pm
How can I remove them.
I found this one...
sp_dropserver.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 7, 2009 at 12:46 pm
DBA (5/5/2009)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 6, 2009 at 8:44 am
Well, its kind of slow today, so... Probably the easiest way is to open EM, right click the table, choose 'Design table', highlight the column, and populate 0 in...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 5, 2009 at 9:32 am
Does your column currently have data in it?
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 5, 2009 at 8:07 am
You can right click the table in EM, and choose All Tasks > Manage Triggers, and you can see the triggers on your table. Not sure if there is...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 4, 2009 at 7:51 am
Karthik
I'm just curious, why do you have two different date formats?
and PerfDate between '01/01/2009' and '24/apr/2009'
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
April 29, 2009 at 6:21 am
If you are using strictly column values, rather than variables, where you might not be able to enter 100.0, you can add *1.0 in the denominator to do the same...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
April 28, 2009 at 6:56 am
Thank you Andrew. Your explaination made it start to stick, more than my reading BOL last night. I guess I can lurk in the performance tuning forum for...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
April 17, 2009 at 7:21 am
Andrew, now I am very confused. I tried adding a clustered index on a test table on two columns, then inserted what I knew to be a duplicate record,...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
April 16, 2009 at 6:17 pm
andrewd.smith (4/16/2009)
ALTER TABLE dbo.Test ADD CONSTRAINT
PK_Test PRIMARY KEY CLUSTERED (RowNum)
CREATE NONCLUSTERED INDEX IX_Test_Company_Date
ON dbo.Test(Company, Date)
ALTER TABLE dbo.Test ADD CONSTRAINT
...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
April 16, 2009 at 6:07 pm
Andrew, thanks for looking further into it. I'm not too savy at how different index schemes affect performance, but clearly this is something I need to think about. ...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
April 16, 2009 at 2:20 pm
Viewing 15 posts - 316 through 330 (of 621 total)