Forum Replies Created
Viewing 15 posts - 1,606 through 1,620 (of 10,144 total)
-
RE: Are the posted questions getting worse?
Grumpy DBA (5/10/2016)
Low and slow (cooking in a smoker) is the way to go.Although it has "butt" in it's name it really is the shoulder.
It's probably from...
-
RE: Are the posted questions getting worse?
Sean Lange (5/10/2016)
ChrisM@Work (5/10/2016)
Sean Lange (5/9/2016)
So I brought back some yummy foods from New Orleans. I got some crawfish and pork sausage, some gator and pork sausage and a couple... -
RE: Help with query excluding certain combo of rows
Try this:
WHERE
Code NOT IN ('GST','TAX', 'COMM')
AND NOT (Ty IN ('A','C') AND [Cr Ind] = 'C'))
-
RE: Are the posted questions getting worse?
BWFC (5/10/2016)
ChrisM@Work (5/10/2016)
BLOB_EATER (5/10/2016)
ChrisM@Work (5/10/2016)
Sean Lange (5/9/2016)
So I brought back some yummy foods from New Orleans. I got some crawfish and pork sausage, some gator and pork sausage and a... -
RE: Are the posted questions getting worse?
BLOB_EATER (5/10/2016)
ChrisM@Work (5/10/2016)
Sean Lange (5/9/2016)
So I brought back some yummy foods from New Orleans. I got some crawfish and pork sausage, some gator and pork sausage and a couple gator... -
RE: Are the posted questions getting worse?
Sean Lange (5/9/2016)
So I brought back some yummy foods from New Orleans. I got some crawfish and pork sausage, some gator and pork sausage and a couple gator fillets. This... -
RE: select from self without FROM-clause in WHERE?
Your observations arise from the necessity to support queries such as this:
SELECT
dk.hpnr,
dk.artnr,
dk.Vorhanden
FROM#d1 as dk
WHERE EXISTS (SELECT 1 FROM #d2 d2 WHERE d2.hpnr = dk.hpnr)
The...
-
RE: Who's going to SQL Bits in Liverpool?
Mark Cowne (5/9/2016)
Really enjoyable few days, lots of excellent presentations, Itzik Ben-Gans was simply brilliant. Also got a chance to briefly meet Grant and Steve.I'd like to have bought you...
-
RE: Who's going to SQL Bits in Liverpool?
Eirikur Eiriksson (5/7/2016)
Heading home after a great two days in Liverpool, very good to see you guys again, finally met Gianluca and Hugo, saw Chris, Grant, Steve, Erland, Itzik and... -
RE: rewrite a query
Thanks.
There's plenty of scope for tuning here, few of the indexes are fully supportive.
You have a residual predicate
[SurveillanceDashboardRepository].[dbd].[fResult].[GeoLevel] as [a].[GeoLevel]=(2)
on a 27 million row table. An "actual" execution plan...
-
RE: rewrite a query
Hadrian (4/29/2016)
initial request was to replace views with indexes views with clustered index on it in order to improve performance. indeed I will check the index... -
RE: Are the posted questions getting worse?
Grant Fritchey (4/28/2016)
Technical question:I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need to be able to script...
-
RE: Are the posted questions getting worse?
BLOB_EATER (4/28/2016)
SQLRNNR (4/27/2016)
GilaMonster (4/27/2016)
BLOB_EATER (4/27/2016)
GilaMonster (4/26/2016)
BLOB_EATER (4/26/2016)
GilaMonster (4/26/2016)
SQLRNNR (4/26/2016)
The sith lord is Supreme Leader Snoke and suspected to be Darth Plagueis (the one that can create life from death according... -
RE: Who's going to SQL Bits in Liverpool?
Beatrix Kiddo (4/28/2016)
ChrisM@Work (4/28/2016)fear not, very few of them are attention-seeking party animals.
😀 Yeah, I think non-DBAs would definitely say that about us. I might see you at Inside ...
-
RE: Who's going to SQL Bits in Liverpool?
Beatrix Kiddo (4/28/2016)
tindog (4/27/2016)
I'd love to go to this, but have no SQL-y friends and get v anxious in unfamiliar places where I don't know anyone! (Never been to Liverpool)I'll...
Viewing 15 posts - 1,606 through 1,620 (of 10,144 total)