Viewing 15 posts - 4,906 through 4,920 (of 5,678 total)
As a note, you comment that you were instructed to write a script that shows the CC numbers with all but the last 4 as *s. Did they intend...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 17, 2010 at 10:42 am
I know that I have a broad set of knowledge about what SQL Server can do, but not a very deep set of skills in any one area.
I believe a...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 17, 2010 at 10:31 am
Hm, Identity column seeded at 1000001 and then obfuscate that into the 'LB' format with a calculated column should work as well.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 16, 2010 at 4:11 pm
Are you on the same domain, or are you VPN'ing in? It sounds like the VPN is doing something strange that you don't get when you're RDC'd.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 16, 2010 at 4:10 pm
rconway-574047 (11/16/2010)
I will try it from the user standpoint. The user is looking at a report that has 50 questions with a total of 500 respondents. Question 1...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 16, 2010 at 4:05 pm
Please clarify. You have SQL 2005 SSMS installed on the laptop and you're connecting to the server, or you have a desktop SQL Engine running on your laptop running...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 16, 2010 at 3:59 pm
WayneS (11/16/2010)
Something that is really interesting in an odd way: if you build the test data first, and then separately run...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 16, 2010 at 3:49 pm
Steve Jones - SSC Editor (11/16/2010)
CirquedeSQLeil (11/16/2010)
Do we have any opinions on the following (comments included)?http://www.sqlservercentral.com/blogs/steve_jones/archive/2010/11/16/another-plagiarizer.aspx
I think the author is 100% correct and a genius 😛
You know, I think I've...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 16, 2010 at 3:07 pm
GrassHopper (11/16/2010)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 16, 2010 at 2:48 pm
I still think you're locked into a bad approach.
You can call a foreign procedure from a local one. For example, lets say I had a linked server DWServ2, and...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 16, 2010 at 2:43 pm
This gets complex, but the simple form of the method is this:
You don't call the job, you call the SSIS package (dtsexec.exe) and via that method, you feed it variable...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 16, 2010 at 2:23 pm
As an update:
This:
SELECT@NumAccounts= 1000,
@DateSpan= 4000
Is at an hour and climbing. Not sure which version is the problem child.
EDIT: Finally completed
Death to the lack of the Tally!
Test done for 1000...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 16, 2010 at 2:18 pm
rconway-574047 (11/16/2010)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 16, 2010 at 2:17 pm
KcV (11/15/2010)
Thanks man, for helping mein answer to your questions :
1. I did not changed anything except indexing on a table. (query,table,data,fields all are as it is)
Is there anyone else...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 16, 2010 at 2:08 pm
WayneS (11/16/2010)
LutzM (11/16/2010)
Chris Morris-439714 (11/16/2010)
Am I being too harsh with this poster?
If what you did over there would be considered being harsh, I'd have to stop posting!!
The effort you put...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 16, 2010 at 1:58 pm
Viewing 15 posts - 4,906 through 4,920 (of 5,678 total)