Viewing 15 posts - 1,966 through 1,980 (of 6,401 total)
The column you want is max_length not precision.
October 22, 2015 at 7:34 am
OK, changed the timeout to 35 still got errors, changed it to 60 still got errors.
Back to the investigations
October 22, 2015 at 7:32 am
djj (10/22/2015)
Ed Wagner (10/22/2015)
anthony.green (10/22/2015)
Ed Wagner (10/21/2015)
happygeek (10/21/2015)
DonlSimpson (10/21/2015)
crookj (10/21/2015)
Ed Wagner (10/21/2015)
djj (10/21/2015)
Ed Wagner (10/21/2015)
crookj (10/21/2015)
Ed Wagner (10/21/2015)
BL0B_EATER (10/21/2015)
happygeek (10/20/2015)
PhoneLine
Wire
Tap
Keg
Jug
Head
Honcho
Jefe
Sherrif
Shot (play on the near-spelling of the name)
Who
Pinball
Wizard
Merlin
October 22, 2015 at 5:24 am
Us an OR to search the exact string
Just uncomment a particular string at the top you want to search
--declare @searchstring varchar(100) = '\\Dpo-doctest1\Citibank Files\Citibank\07-JULY\20150703\C12'
--declare @searchstring varchar(100) = '\\Dpo-doctest1\Citibank Files\Citibank\07-JULY\20150703\C12\29P'
--declare @searchstring...
October 22, 2015 at 3:23 am
Where is your company based?
I contract in the UK. Travel to clients is expensed to your company not the client. The only time you can claim expenses back...
October 22, 2015 at 3:05 am
Ed Wagner (10/21/2015)
happygeek (10/21/2015)
DonlSimpson (10/21/2015)
crookj (10/21/2015)
Ed Wagner (10/21/2015)
djj (10/21/2015)
Ed Wagner (10/21/2015)
crookj (10/21/2015)
Ed Wagner (10/21/2015)
BL0B_EATER (10/21/2015)
happygeek (10/20/2015)
PhoneLine
Wire
Tap
Keg
Jug
Head
Honcho
Jefe
Sherrif
Shot (play on the near-spelling of the name)
Who
October 22, 2015 at 2:59 am
Initial way would be to reverse the string, find the first \ strip out the remaining characters and compare.
Something like this
create table #TRFile (filepath varchar(100))
insert into #TRFile values...
October 22, 2015 at 2:55 am
Brent Ozar has a good script sp_blitzcache[/url], it scrapes the plan cache for whats in cache, you can get it to log results to a table to compare before and...
October 22, 2015 at 1:57 am
Put a filter on the host name and filter out anything that's not the server.
October 22, 2015 at 1:51 am
Ed Wagner (10/20/2015)
anthony.green (10/20/2015)
Ed Wagner (10/20/2015)
anthony.green (10/20/2015)
Ed Wagner (10/19/2015)
DonlSimpson (10/19/2015)
ZZartin (10/19/2015)
Ed Wagner (10/19/2015)
anthony.green (10/19/2015)
Ray K (10/19/2015)
Ed Wagner (10/19/2015)
crookj (10/19/2015)
Ed Wagner (10/19/2015)
anthony.green (10/19/2015)
djj (10/19/2015)
RetrievePost (HTTP request)
Office
Depot
Home
Plate
Pie
Cake
Butter
Toast
Bread
Pudding
Custard
Apple
Cider
Ale
October 20, 2015 at 5:42 am
Ed Wagner (10/20/2015)
anthony.green (10/20/2015)
Ed Wagner (10/19/2015)
DonlSimpson (10/19/2015)
ZZartin (10/19/2015)
Ed Wagner (10/19/2015)
anthony.green (10/19/2015)
Ray K (10/19/2015)
Ed Wagner (10/19/2015)
crookj (10/19/2015)
Ed Wagner (10/19/2015)
anthony.green (10/19/2015)
djj (10/19/2015)
RetrievePost (HTTP request)
Office
Depot
Home
Plate
Pie
Cake
Butter
Toast
Bread
Pudding
Custard
Apple
October 20, 2015 at 5:20 am
The core app is a 3rd party app and DB, they just hook in and deploy their own changes on top of what they develop for the client.
Do have some...
October 20, 2015 at 4:47 am
Happy to help.
Please do take a look at the posting code/data link in my signature, will help us to help you that bit quicker as we can easily recreate your...
October 20, 2015 at 4:46 am
OK, so you want one row not two.
Something like the second select?
create table #nakliyeFiyat
(ID INT,
gidis INT,
donus INT,
tarih datetime,
fiyat int,
aractipi int
)
create table #aractipleri
(id int,
aractipi varchar(10)
)
create table #il
(id int,
iladi varchar(10),
iladi2 varchar(10)
)
insert into...
October 20, 2015 at 4:30 am
Viewing 15 posts - 1,966 through 1,980 (of 6,401 total)