Viewing 15 posts - 6,286 through 6,300 (of 7,631 total)
INSERT into TargetDB.dbo.OutTable
SELECT * From SourceDB.dbo.InTable
[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 1:51 pm
I'm just curious Brandie, why do you think that you need the Foreign Key in your Data Warehouse?
[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 12:00 pm
SQL_DBA (7/18/2008)
staging stable is not going to work as the length of the data is unknown. it may be 10 characters or 10,000 characters.
A Staging table will work. ...
[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 9:17 am
Jacob:
Hopefully a few more answers for you:
0) Your users just login to Windows as they normally do, then run the app. For bad apps, they will also...
[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 8:54 am
rbarryyoung (7/13/2008)
And of course, there are many consultants here...
[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 18, 2008 at 6:45 pm
This is the only clear reference that I can find to this specific error message and how to debug it:http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=356938&SiteID=1
[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 18, 2008 at 5:21 pm
Try the easy answer first: Any reason that you cannot use "Generate Scripts" from SSMS?
[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 18, 2008 at 3:59 pm
Ummm... I cannot figure out what this is supposed to do? For instance, what is "sps"?
[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 18, 2008 at 3:35 pm
Mike Good (7/17/2008)
When we start using "WITHOUT LOGIN" users we're going to have to abandon notion of...
[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 18, 2008 at 3:21 pm
Can you post the actual messages?
[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 18, 2008 at 3:04 pm
graham cleverly (7/14/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 14, 2008 at 8:54 am
Hmmm, your question and the title of this post seem to have nothing to do with each other.
But OK, "Solid State Disks" is an archaic term for a physical device...
[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 13, 2008 at 6:26 pm
Here you go:
Create proc spTable_LoadDynamic (@TableName as sysname, @hdr as varchar(max), @data as varchar(max)) as
/*
Dynamically load a table from a reformatted Excel export file.
13-July-2008, RBarryYoung
Test script:
declare @headers as varchar(max),...
[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 13, 2008 at 5:48 pm
Jeffrey Williams (7/13/2008)
Hi, I posted a solution on Friday - but I guess I took too long writing it up and it was lost.
This happens to all of us from...
[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 13, 2008 at 5:19 pm
You need to go back to whoever you bought it from and get the license key from them.
[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 13, 2008 at 5:02 pm
Viewing 15 posts - 6,286 through 6,300 (of 7,631 total)