Viewing 15 posts - 3,886 through 3,900 (of 9,399 total)
If you want to refer to col1 in table2, you can refer to it in the select statement. Example:
SELECT col4, col5, col2
FROM table2;
If, on the other hand,...
February 10, 2016 at 3:13 pm
djj (2/10/2016)
whereisSQL? (2/10/2016)
crookj (2/10/2016)
DonlSimpson (2/10/2016)
Ed Wagner (2/10/2016)
Revenant (2/10/2016)
Grumpy DBA (2/10/2016)
djj (2/10/2016)
Ray K (2/10/2016)
djj (2/10/2016)
SQLRNNR (2/10/2016)
Ed Wagner (2/10/2016)
ThomasRushton (2/10/2016)
Ed Wagner (2/10/2016)
crookj (2/10/2016)
Ed Wagner (2/10/2016)
Grumpy DBA (2/10/2016)
Ed Wagner (2/10/2016)
BL0B_EATER (2/10/2016)
SQLRNNR (2/10/2016)
deadlockvictim
Predator
Schwarzenegger
Governor
Resource
Time
Hammer
Sledge
Steam
Ship
Plane
Train
Automobile
Commute :doze:
Traffic
Light
Dark
Lord
King
Dictator
February 10, 2016 at 2:08 pm
Revenant (2/10/2016)
Grumpy DBA (2/10/2016)
djj (2/10/2016)
Ray K (2/10/2016)
djj (2/10/2016)
SQLRNNR (2/10/2016)
Ed Wagner (2/10/2016)
ThomasRushton (2/10/2016)
Ed Wagner (2/10/2016)
crookj (2/10/2016)
Ed Wagner (2/10/2016)
Grumpy DBA (2/10/2016)
Ed Wagner (2/10/2016)
BL0B_EATER (2/10/2016)
SQLRNNR (2/10/2016)
deadlockvictim
Predator
Schwarzenegger
Governor
Resource
Time
Hammer
Sledge
Steam
Ship
Plane
Train
Automobile
Commute :doze:
Traffic
February 10, 2016 at 1:06 pm
ThomasRushton (2/10/2016)
Ed Wagner (2/10/2016)
crookj (2/10/2016)
Ed Wagner (2/10/2016)
Grumpy DBA (2/10/2016)
Ed Wagner (2/10/2016)
BL0B_EATER (2/10/2016)
SQLRNNR (2/10/2016)
deadlockvictim
Predator
Schwarzenegger
Governor
Resource
Time
Hammer
Sledge
February 10, 2016 at 9:21 am
crookj (2/10/2016)
Ed Wagner (2/10/2016)
Grumpy DBA (2/10/2016)
Ed Wagner (2/10/2016)
BL0B_EATER (2/10/2016)
SQLRNNR (2/10/2016)
deadlockvictim
Predator
Schwarzenegger
Governor
Resource
Time
February 10, 2016 at 7:20 am
michael_okonji (2/10/2016)
sounds awesome Mike and Ed. I'll try that today... let you guys know how that went. Have a great day at work today
You too. Glad to help.
Don't forget...
February 10, 2016 at 5:32 am
Grumpy DBA (2/10/2016)
Ed Wagner (2/10/2016)
BL0B_EATER (2/10/2016)
SQLRNNR (2/10/2016)
deadlockvictim
Predator
Schwarzenegger
Governor
February 10, 2016 at 5:29 am
Great question, Steve, thanks. This is an area I've been interested in for some time and I'm just starting to really dig into it.
February 10, 2016 at 5:28 am
julienchappel 38298 (2/9/2016)
None of the formula options produced the expected result. The correct answer to this QOD is None of the answers is correct.
That was part of the question. ...
February 10, 2016 at 5:00 am
BL0B_EATER (2/10/2016)
SQLRNNR (2/10/2016)
deadlockvictim
Predator
February 10, 2016 at 4:56 am
whereisSQL? (2/9/2016)
HappyGeek (2/9/2016)
TerabytesPetabytes
Space
February 9, 2016 at 6:25 pm
Here's another approach if you do this type of thing frequently.
SELECT s.Item
FROM dbo.table_name t
CROSS APPLY dbo.DelimitedSplit8K(t.file_name, '_') s
WHERE s.ItemNumber = 3;
This may...
February 9, 2016 at 6:24 pm
SQL-DBA-01 (2/9/2016)
I captured wait stats for 3 hrs and during the period I found that this wait stats "PREEMPTIVE_OS_AUTHENTICATIONOPS" number is v high.
Should I suspect this to any trouble with...
February 9, 2016 at 6:18 pm
SQL-DBA-01 (2/9/2016)
I found that in one of the servers the max dop value is set to 1 but in the server it has 8 cores.
Is this fine to have 8...
February 9, 2016 at 6:14 pm
Lynn Pettis (2/9/2016)
Ed Wagner (2/9/2016)
Lynn Pettis (2/9/2016)
Phil Parkin (2/9/2016)
Lynn Pettis (2/9/2016)
Silver Spoon(2/9/2016)
February 9, 2016 at 6:06 pm
Viewing 15 posts - 3,886 through 3,900 (of 9,399 total)