Viewing 15 posts - 5,101 through 5,115 (of 5,678 total)
Figured it out again (I think):
DECLARE @beginYear DATETIME
SET @beginYear = DATEADD (yy, YEAR(getdate()) - 1900 , 0)
PRINT dateadd( dd, (DATEPART( wk, getdate()) - 1) * 7 - datepart(dw, @beginYear)...
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 2, 2010 at 4:02 pm
Numerous.
Stored Cache in engine.
Security allowed execute only on proc and no direct data access.
Multiple call reusability.
(Depending on tasks) Can do multi-step processes that a view cannot.
Helps to protect against SQL...
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 2, 2010 at 3:45 pm
Well, there's
DATEPART( mm, @date) which will give you the month.
DATEPART( ww, @date) which will give you the week # in the year.
You'll use those for sorting.
For display, you can then:
DATENAME(...
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 2, 2010 at 3:42 pm
Roy Ernest (11/2/2010)
Thank You. I saw some sunlight about 5 minutes back. So that is a good sign. 🙂 After 24 hrs.. 🙂
Must have been one wild ride. Glad...
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 2, 2010 at 3:11 pm
Nope. I have only used the return value, or selected the results of the exec into a temp table and then used whatever I needed from the #tmp.
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 2, 2010 at 3:10 pm
Gift Peddie (11/2/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 2, 2010 at 3:08 pm
Figured out the problem. It's because the 'tabs' are converted to spaces when I copy/paste the code in. Seeing if it works from plain encoding. Yes, plain...
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 2, 2010 at 2:59 pm
naidu4u (11/2/2010)
I am unable to structure the code, I mean its becoming really difficult to insert the row column in this tmp table...(by using views since I can really insert...
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 2, 2010 at 2:54 pm
SQL33 (11/2/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 2, 2010 at 2:53 pm
I must say I'm suddenly quite happy to be living in AZ. We don't mess with that old farmer's wit of a time system. Savings time... bah! ...
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 2, 2010 at 2:45 pm
OS is reading and writing to the drive, SQL is reading/writing to its Data file, and SQL is reading/writing to its Log file.
Add one more, the tempdb is churning on...
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 2, 2010 at 2:42 pm
What kind of CPU pressure is on your production box? It's a standard signal wait, well, for the class of them. I found this query to help measure...
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 2, 2010 at 1:53 pm
mymail.default (11/2/2010)
Craig,I made the SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
and unfortunately it did not improve things at all...
Strange! There should be something else causing the issue.
Rats.
One important thing I...
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 2, 2010 at 1:48 pm
Alright, end to end code. SQL33, please note, I have no idea what a number of these fields mean, and if I got your spacing off, there should be...
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 2, 2010 at 1:41 pm
GilaMonster (11/2/2010)
Correct. Index names only have to be unique within a table, while constraint names have to be unique in the DB
I so rarely create constraints I'd forgotten that. ...
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 2, 2010 at 12:37 pm
Viewing 15 posts - 5,101 through 5,115 (of 5,678 total)