Viewing 15 posts - 1,801 through 1,815 (of 5,678 total)
ricardo_chicas (2/8/2012)
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
February 9, 2012 at 12:10 pm
L' Eomot Inversé (2/9/2012)
MysteryJimbo (2/9/2012)
HowardW (2/9/2012)
MysteryJimbo (2/9/2012)
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
February 9, 2012 at 12:01 pm
Be vewy vewy qwiet, we're huntin' wabbits.
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
February 8, 2012 at 1:18 pm
ricardo_chicas (2/7/2012)
I have a very large table ( 338782585 rows, 552 gb ) , usually it is "fast" to retrieve data from it, but I have an special case...
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
February 7, 2012 at 5:27 pm
Don't use between.
Use something along these lines:
DECLARE @param1 DATETIME, @param2 DATETIME
SELECT @param1 = '20120101',
@param2 = '20120129'
SELECT * FROM tbl...
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
February 7, 2012 at 5:24 pm
Lucky9 (2/7/2012)
I have tested the query provided by you it works fine for the first and third record but the output for...
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
February 7, 2012 at 5:21 pm
Like so:
Create table #TestClient
(ID int,
InternalCode nvarchar(100))
Insert into #TestClient values(1,'abctest12-2-1-12345-12-01-08')
Insert into #TestClient values(2,'xyztest24-1-2-2345-2013-1-5')
Insert into #TestClient values(3,'QRStest69-2-3-34568-05-1-09')
Insert into #TestClient values(4,'TUVtest99-9-8-56789-2011-9-10')
select * from #testclient
select SUBSTRING( InternalCode,
CHARINDEX( '-', InternalCode,
CHARINDEX( '-', InternalCode,
CHARINDEX( '-',...
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
February 7, 2012 at 4:40 pm
savethytrees (2/7/2012)
What happens to the non clustered index on those tables if you move the primary key index to a new filegroup using the option that you mentioned?
I assume...
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
February 7, 2012 at 4:29 pm
wilson_acong (2/7/2012)
hmm.. "check your pagefaults. Make sure you're not hammering the swapfile." this sounds interesting would you mind elaborate how to perform that checking?
Sure. In perfmon (Performance Monitor) there's...
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
February 7, 2012 at 4:23 pm
wilson_acong (2/7/2012)
The Recovery model is Simple. Whole data size is approx close to 301GB
Yes, I need all the data. Because we...
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
February 7, 2012 at 4:05 pm
CELKO (2/7/2012)
This is minimal polite behavior on a SQL forum.
Seriously? Would you like to be the pot, or the kettle, for the remainder of that conversation?
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
February 7, 2012 at 3:28 pm
Koen Verbeeck (2/7/2012)
Lynn Pettis (2/7/2012)
Kassondra gave birth to a healthy baby boy yesterday in Germany. Grayson Matthew was...
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
February 7, 2012 at 2:38 pm
Be aware that lookup is case sensitive. You may need to use a wrapper on your columns to turn them all to UPPER (I usually use a derived column...
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
February 7, 2012 at 2:36 pm
justintime (2/7/2012)
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
February 7, 2012 at 2:31 pm
You're not off Jessie, but it will depend on the version of the SQL Server if it will use the view indexing or bypass to the tables depending on your...
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
February 7, 2012 at 2:28 pm
Viewing 15 posts - 1,801 through 1,815 (of 5,678 total)