Viewing 15 posts - 241 through 255 (of 498 total)
OOPS... I forgot... You'll also have to strip off the last Union in the above...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
January 13, 2004 at 12:46 pm
Give this a try. Please note that I just whipped this up so it is untested!
-- Run this script and paste the results into a new QA Window. Then run...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
January 13, 2004 at 12:44 pm
If you run this SP in QA do you get the ???? in the data? If not I would start looking at what is happening when you call the SP...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
January 13, 2004 at 11:03 am
Yes you can. Look at the system stored procedures that start with sp_trace_.
IE: sp_trace_create, sp_trace_generateevent, sp_trace_setstatus...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
January 12, 2004 at 2:41 pm
I would highly suggest you call Product Support Services to resolve this.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
January 12, 2004 at 2:37 pm
Try this...
SELECT YourMonth = datepart(mm,CONVERT(datetime,convert(int,'057')))
, YourDay = datepart(dd,CONVERT(datetime,convert(int,'057')))
, YourDate = convert(varchar, convert(varchar, datepart(mm,CONVERT(datetime,convert(int,'057')) ) ) + '/'
+ convert(varchar, datepart(dd,CONVERT(datetime,convert(int,'057')) )) + '/'
+ '20' + '04')
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
January 12, 2004 at 2:34 pm
None that I know of off the top of my head. Besides, why reinvent the wheel? Profiler is very efficient and works very well!
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
January 12, 2004 at 2:16 pm
You might notice better performance if you use an outer join instead of the not exists. IE:
SELECT ...
FROM tblMMStudentTestScores TS
LEFT JOIN #tblMMStudentTestScoresTEMP T ON ...
WHERE T.?? IS NULL
If you have...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
January 12, 2004 at 2:14 pm
I think the best way to do this would be with Profiler. If you use the template SQLProfilerTSQL_Replay it will capture the actual calls to the SP along with the...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
January 12, 2004 at 2:09 pm
No I don't use the dbproject as a DAL. Since I only do TSQL work for the most part I use the DB project to hold all of my SP...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
January 12, 2004 at 10:41 am
Hey Frank! I use VSS Too... I also do all of my TSQL work on Stored Procedures through a database project in Visual Studio. I like to use a lot...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
January 11, 2004 at 2:22 pm
Even better yet. When in QA hit F8 to bring up the object browser. Drill down to the SP you want to "EDIT" and right click on it. Hit Edit...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
January 9, 2004 at 1:45 pm
I agree with the idea of using replication for this. Merge replication isn't too bad but I would stay away from using Managed Identities if at all possible.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
January 9, 2004 at 1:32 pm
Christy,
You've gotten a lot of good advise here. I just wanted to answer you specific question on using SP calls for "Simple Selects"....
Yes I would create an SP for simply...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
January 9, 2004 at 12:54 pm
Antares,
I realize that there is no major difference in if you use right or left when properly done. I just found it amusing that he wrote it using a right...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
January 8, 2004 at 10:25 pm
Viewing 15 posts - 241 through 255 (of 498 total)