Viewing 15 posts - 7,396 through 7,410 (of 13,469 total)
that stored proc is used inside other system procedures...if you were to drop it, i guarantee you will, at a minimum, break replication, the SQL Agent, scheduled jobs,let alone lots...
June 13, 2011 at 6:02 am
I'm afraid the answer is "it depends"...we'd need to really see the procedure to give you a peer review and tell you what we thing is good, bad, or could...
June 13, 2011 at 5:35 am
you need to replace vbCrLf with the html break tag <br /> & vbCrLf, whether in the data source at SQL, or in the textbox/panel you are loading the data...
June 11, 2011 at 7:48 am
ok one imporvement i see is some out of date statistics on the Table CorrespondenceLog;
the estimated plan expecting 4 rows, but the actual ended up using almost 12 million.
can you...
June 10, 2011 at 1:53 pm
great greg...can you post an Actual execution plan? that's where a few more details will help as well
June 10, 2011 at 1:32 pm
ok i see what you are saying...you have a slow query, and at least a portion of the slowness is probably attributable to the grabbing lots of rows with ...
June 10, 2011 at 1:17 pm
SQL Server indexes are constrained to a maximum width of 900 bytes; so you could include *part* of that text column, potentially;
typically when you have to search a text/varchar(max) column,...
June 10, 2011 at 1:02 pm
i wouldn't say bad practice; you'd have to review the logic to determine if the data REALLY needs to go into a temp table (like it's being further processed or...
June 10, 2011 at 12:43 pm
lol this made me think and change my signature!
I was going to do the expected response like "Well every app [font="#FF0000"]I[/font] create is perfect", but i couldn't keep a straight...
June 10, 2011 at 11:43 am
ok, i think you can simply alter the column.
ALTER TABLE MyTable ALTER COLUMN MyNTextColumn VARCHAR(MAX)
let us know if that fails, it worked on a simple test table i created...but if...
June 9, 2011 at 3:15 pm
here's the full reference to Cast And Convert; it's good to read, it's something you end up using a lot
http://msdn.microsoft.com/en-us/library/ms187928.aspx
Select
convert(nvarchar(max),TheNTextColumn) AsColumnName
From TableName
June 9, 2011 at 2:44 pm
i've used this for pipe delimited; does this help?
EXECUTE master.dbo.xp_cmdshell 'bcp "SELECT object_name(object_id) As TbLName,name as ColName FROM SandBox.sys.columns ORDER BY object_name(object_id), column_id" queryout C:\Data\Objects.txt -t"|" -c -T '...
June 9, 2011 at 12:22 pm
where is the DECLARE @Number bigint statement?
where is the SET Number = CONVERT(bigint,????) statment?
what you posted is disconnected from my perspective...iu think you need to show more of the offending...
June 9, 2011 at 9:07 am
so you can only have 365 records per year(or really one record per day)?
that's what a primary key based on just the days would limit you to? does that...
June 9, 2011 at 8:45 am
you'll need a larger data type...bigint might hold it.
the largest int is ~2 billion...your value's a few orders larger than that.
select convert(bigint,2011060910105711742)
June 9, 2011 at 8:33 am
Viewing 15 posts - 7,396 through 7,410 (of 13,469 total)