Viewing 15 posts - 6,271 through 6,285 (of 7,631 total)
Muhammad Furqan (7/21/2008)
Sorry guys!that was my fault.
i didnt troubleshoot it well and finally figured out that it was not the UDF causing problem, it was something else.
Thanks again!
Could you tell...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 21, 2008 at 6:19 am
Actually Abhijit's can be fixed pretty easily:
SELECT OBJECT_NAME(object_id), Rows FROM sys.partitions WHERE index_id < 2
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 21, 2008 at 6:17 am
Is this homework? If so, can you be explict about what kind of help your school's policy allows us to give you?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 21, 2008 at 12:29 am
You are going to have to provide us with more information. Please post a sample script and CLR code that can demonstrate the problem.
See this link for some guidelines...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 21, 2008 at 12:07 am
Jonathan Kehayias (7/20/2008)
rbarryyoung (7/20/2008)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 20, 2008 at 11:48 pm
Well, certificates are what MS is trying to push everyone towards. However, that is even more complicated and confusing, IMHO.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 20, 2008 at 8:49 pm
The problem is that there is virtually nothing worthwhile that you can do in SQLCLR that isn't either unsafe, unsupported, impossible or just better done in T-SQL to begin with....
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 20, 2008 at 7:19 pm
We cannot see the XML. Either post it as an attachment or use the simple-talk prettifier here http://extras.sqlservercentral.com/prettifier/prettifier.aspx
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 20, 2008 at 7:07 pm
Glad I could help.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 20, 2008 at 6:33 pm
Abhijit (7/20/2008)
This will return all tables Rows informantion...SELECT OBJECT_NAME(object_id), Rows FROM sys.partitions WHERE index_id = 1
Actually, this only works on tables with a clustered index, and not all tables have...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 20, 2008 at 12:21 pm
FYI: sp_MakeWebTask is deprecated in 2005 and supposedly removed in 2008 (I haven't checked this). BOL recommends using Reporting Services for this(?).
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 20, 2008 at 11:56 am
This view works, and provides a lot more information as well:
http://www.sqlservercentral.com/scripts/tables/62545/
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 20, 2008 at 11:42 am
Well if your title is really correct, then you want something like this"
Declare @str NVarchar(MAX)
Set @str = ''
Select @str = @str + fielda
From TableName
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 20, 2008 at 11:31 am
rinu philip (7/20/2008)
delta dirac (4/1/2008)
hi everybody,is it possible to hide my tables (i don't want customers to see my columns).
thanks.
This could be achieved ny giving specific permissions to the customers....
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 20, 2008 at 6:34 am
FYI, although I would not advise it, this can be done.
What you would need to do is to add a "handle" argument to your function, and then find a way...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 19, 2008 at 10:16 pm
Viewing 15 posts - 6,271 through 6,285 (of 7,631 total)