Viewing 15 posts - 136 through 150 (of 360 total)
Thanks Guys. That was helpful.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
April 17, 2012 at 10:45 am
Thats the DDL for the source table
CREATE TABLE [dbo].[Channels2](
[Name] [varchar](50) NULL,
[ChannelRate] [varchar](50) NULL,
[MAS90ID] [varchar](50) NULL,
[SLXID] [varchar](50) NULL,
[CommPlan] [varchar](50) NULL
) ON [PRIMARY]
GO
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
April 17, 2012 at 10:16 am
Thanks Gail and SQLBalls for the info.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
April 11, 2012 at 10:13 am
Thanks Gail.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
April 3, 2012 at 11:51 am
My bad, I pasted the wrong sql. The correct select statement is pasted below:
exec sp_executesql N'SELECT
[Project2].[JobID] AS [JobID],
[Project2].[Name] AS [Name],
[Project2].[OwnerAppName] AS [OwnerAppName],
[Project2].[OwnerAppVersion] AS [OwnerAppVersion],
[Project2].[Pri] AS...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
April 3, 2012 at 10:19 am
Thanks for the Quick response Gail. An EF generated select runs first which is as shown below:
SELECT
[Extent1].[Pri] AS [Pri],
[Extent1].[JobID] AS [JobID],
[Extent1].[Name] AS [Name],
[Extent1].[OwnerAppName] AS [OwnerAppName],
[Extent1].[OwnerAppVersion]...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
April 3, 2012 at 10:05 am
Any ideas??
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
March 23, 2012 at 8:22 am
My MSDTC Trace log file is not helping much as well. Please post your valuable inputs if anyone has seen such issues. Thanks a bunch.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
March 22, 2012 at 2:52 pm
Unable to parse the MSDTC tracelog files in WIndows server 2008 R2 without these Tracefmt.exe and traceprt.dll.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
March 22, 2012 at 1:37 pm
And that number is 10/minute? 20/minute? 2000/minute? How are you judging that it is too many? Every time a connection is reusing a pool, it is executing this. So what...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
March 21, 2012 at 3:02 pm
Thats based on the count (number of times it appears in the trace file)
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
March 21, 2012 at 11:46 am
Sure John. I usually prefer the scripting approach as well because I can store them in my repository as they are changes to structure of a table.
Thanks
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
March 21, 2012 at 9:28 am
GSquared..That goes straight into my performance hit checklist.
Thanks much
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
March 21, 2012 at 8:52 am
Mystery Limbo and Lowell thanks for the info. I was not aware of this.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
March 21, 2012 at 8:47 am
Cool...it warns me. It wont recreate the table just like that when I have data.
Thanks Lynn.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
March 21, 2012 at 8:44 am
Viewing 15 posts - 136 through 150 (of 360 total)