Viewing 15 posts - 1,696 through 1,710 (of 14,953 total)
If you mean timeout values, you can change that in your connection configuration for the application. As Gail mentioned, it's not usually an SQL Server property. There is...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 17, 2012 at 6:32 am
Sean Lange (4/16/2012)
Brandie Tarvin (4/16/2012)
WayneS (4/16/2012)
Brandie Tarvin (4/16/2012)
2) How...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 16, 2012 at 11:47 am
capn.hector (4/13/2012)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 16, 2012 at 8:17 am
The only kind of function you can insert rows into in SQL Server is a single-table inline-table-value-function.
Those are defined like:
create function dbo.MyFunction (@Param datatype)
returns table
as
return (select columns from dbo.MyTable where...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 16, 2012 at 8:12 am
The two main drawbacks to indexed views are the limits caused by schema-binding, and the fact that they do slow down insert/update/delete operations. They also require the usual maintenance...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 13, 2012 at 9:51 am
You don't need to know the bad characters at all. White-list, don't black-list. It's more secure, easier, and faster.
You could modify my version to use a table of...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 13, 2012 at 8:15 am
L' Eomot Inversé (4/13/2012)
SQLRNNR (4/12/2012)
Steve Jones - SSC Editor (4/12/2012)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 13, 2012 at 8:09 am
To the original question: Apply. I've rarely seen a "need a DBA" ad that didn't list impossible, silly, contradictory, or psychotic requirements, and sometimes more than one of those....
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 13, 2012 at 8:05 am
On seconds runs (taking advantage of caching), my update-only version of your script took about 11 seconds, while my script took 3.8 seconds.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 13, 2012 at 7:07 am
jcrawf02 (4/12/2012)
GSquared (4/12/2012)
Lynn Pettis (4/12/2012)
What would happen here on SSC if the TOP 25 posters did nothing but lurk for 24 hours?
I'm in the top 25 (usually in the top...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 13, 2012 at 6:59 am
You can't compare a Select to an Update.
Here's a test of my method, using the test data you came up with:
SET NOCOUNT ON ;
IF OBJECT_ID(N'tempdb..#t') IS NOT NULL
...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 13, 2012 at 6:53 am
Should be fine then, I would think.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 13, 2012 at 6:33 am
Shrinking data and log files usually just results in them filling up and growing again. With the added benefit, in the data file, of fragmenting your indexes and thus...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 12, 2012 at 1:38 pm
Lynn Pettis (4/12/2012)
GSquared (4/12/2012)
Lynn Pettis (4/12/2012)
GSquared (4/12/2012)
Eugene Elutin (4/12/2012)
...
It's entirely possible someone with better C#/VB.NET skill than mine can make a CLR function that's faster, but the options I...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 12, 2012 at 1:33 pm
Lynn Pettis (4/12/2012)
What would happen here on SSC if the TOP 25 posters did nothing but lurk for 24 hours?
I'm in the top 25 (usually in the top 10), and...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 12, 2012 at 12:44 pm
Viewing 15 posts - 1,696 through 1,710 (of 14,953 total)