Viewing 15 posts - 5,296 through 5,310 (of 9,399 total)
If you have error log entries saying that a transaction can't be committed, then I'd say you should worry about it if that transaction is important to you, the owner...
August 27, 2015 at 1:34 pm
whereisSQL? (8/27/2015)
Ed Wagner (8/27/2015)
Revenant (8/27/2015)
Ed Wagner (8/27/2015)
whereisSQL? (8/27/2015)
Ed Wagner (8/27/2015)
ZZartin (8/27/2015)
djj (8/27/2015)
Ed Wagner (8/26/2015)
Luis Cazares (8/26/2015)
eccentricDBA (8/26/2015)
Ed Wagner (8/26/2015)
whereisSQL? (8/26/2015)
Ed Wagner (8/26/2015)
crookj (8/26/2015)
whereisSQL? (8/26/2015)
Ed Wagner (8/26/2015)
FireDrill
Dentist
Shot
Tequila
Sunrise
Siesta
Fiesta
Food
Hunger
Hamburger
Cheeseburger
Fries
Onion Rings
Tower
Babel
Hebrew
Greek
August 27, 2015 at 1:26 pm
Continuing on pietlinden's approach, first determine your minimum threshold per volume and your tracking requirements - once a day, once every 6 hours, once an hour, etc.
Your checker procedure fires...
August 27, 2015 at 1:26 pm
Revenant (8/27/2015)
Ed Wagner (8/27/2015)
whereisSQL? (8/27/2015)
Ed Wagner (8/27/2015)
ZZartin (8/27/2015)
djj (8/27/2015)
Ed Wagner (8/26/2015)
Luis Cazares (8/26/2015)
eccentricDBA (8/26/2015)
Ed Wagner (8/26/2015)
whereisSQL? (8/26/2015)
Ed Wagner (8/26/2015)
crookj (8/26/2015)
whereisSQL? (8/26/2015)
Ed Wagner (8/26/2015)
FireDrill
Dentist
Shot
Tequila
Sunrise
Siesta
Fiesta
Food
Hunger
Hamburger
Cheeseburger
Fries
Onion Rings
Tower
Babel
August 27, 2015 at 1:16 pm
jay-h (8/27/2015)
After we demonstrated that the db from the previous version was much faster on the same server, now suddenly, the vendor stopped saying "it must be your server" and...
August 27, 2015 at 9:54 am
whereisSQL? (8/27/2015)
Ed Wagner (8/27/2015)
ZZartin (8/27/2015)
djj (8/27/2015)
Ed Wagner (8/26/2015)
Luis Cazares (8/26/2015)
eccentricDBA (8/26/2015)
Ed Wagner (8/26/2015)
whereisSQL? (8/26/2015)
Ed Wagner (8/26/2015)
crookj (8/26/2015)
whereisSQL? (8/26/2015)
Ed Wagner (8/26/2015)
FireDrill
Dentist
Shot
Tequila
Sunrise
Siesta
Fiesta
Food
Hunger
Hamburger
Cheeseburger
Fries
Onion Rings
August 27, 2015 at 9:46 am
ZZartin (8/27/2015)
djj (8/27/2015)
Ed Wagner (8/26/2015)
Luis Cazares (8/26/2015)
eccentricDBA (8/26/2015)
Ed Wagner (8/26/2015)
whereisSQL? (8/26/2015)
Ed Wagner (8/26/2015)
crookj (8/26/2015)
whereisSQL? (8/26/2015)
Ed Wagner (8/26/2015)
FireDrill
Dentist
Shot
Tequila
Sunrise
Siesta
Fiesta
Food
Hunger
Hamburger
Cheeseburger
August 27, 2015 at 9:04 am
whereisSQL? (8/27/2015)
djj (8/27/2015)
Ed Wagner (8/26/2015)
Luis Cazares (8/26/2015)
eccentricDBA (8/26/2015)
Ed Wagner (8/26/2015)
whereisSQL? (8/26/2015)
Ed Wagner (8/26/2015)
crookj (8/26/2015)
whereisSQL? (8/26/2015)
Ed Wagner (8/26/2015)
FireDrill
Dentist
Shot
Tequila
Sunrise
Siesta
Fiesta
Food
Hunger
Games
Board
August 27, 2015 at 8:59 am
Let me echo Jeff and Jason - thank you for your persistence!
August 27, 2015 at 8:58 am
SQLRNNR (8/27/2015)
jasona.work (8/27/2015)
Geez, nothing since yesterday morning...Did someone forget to refill the water cooler, or feed the hippo?
Nah - the cable repair man needed exclusive access to the site.
Now that...
August 27, 2015 at 8:46 am
GilaMonster (8/27/2015)
If you can;'t post it, then you're going to have to rewrite it yourself into the form of an in-line table...
August 27, 2015 at 7:09 am
SathishK (8/27/2015)
CREATE VIEW V1 AS
SELECT
T1.Col1, F1.Col1, T1.Col2, T2.Col2...
FROM T1
INNER JOIN T2 ON T1.Col2 = T2.Col1
CROSS APPLY
UDF(T1.Col1, T2.Col2) F1
The inner join...
August 27, 2015 at 6:00 am
J Livingston SQL (8/27/2015)
for clarification, please can you explain in words the business rules for this sort order.thanks
I have to agree - the logic for the sort is not clear....
August 27, 2015 at 5:50 am
I'm sure there are many ways to skin this cat. Initial approaches:
In SSMS, i would query sys.sql_modules and paste the query results into a single file.
select sm.definition
from...
August 27, 2015 at 5:43 am
Edvard Korsbæk (8/27/2015)
Thanks!And so easy.....
Glad to help.
August 27, 2015 at 5:37 am
Viewing 15 posts - 5,296 through 5,310 (of 9,399 total)