Viewing 15 posts - 4,351 through 4,365 (of 8,753 total)
GilaMonster (10/15/2015)
Oh, and the bloody desktop booted clean to windows on the first try tonight and is behaving itself...
Did you just upgrade to Windows 10?
😎
October 16, 2015 at 12:37 am
My suggestion is somewhat different to the previous ones
😎
1) Safety measures first, Backup the database with verify etc.
2) Create a new file group, add a new data file to it...
October 16, 2015 at 12:28 am
Further on Luis's post, the NULL represents unknown or missing, in the realm of financial transactions that concept is somewhat irrelevant, unknown payment is equivalent of a 0 payment, if...
October 15, 2015 at 1:16 pm
GilaMonster (10/15/2015)
BL0B_EATER (10/15/2015)
October 15, 2015 at 12:22 pm
There is nothing wrong with this DDL, works perfectly. Just a hunch, have you run DBCC CHECKDB on that database recently? Also is this script generated from the table set...
October 15, 2015 at 12:52 am
christophe.bernard 47659 (10/14/2015)
thanks for your time that's exactly what i want ..and now that's work ..
I don't know why the property of this object is...
October 14, 2015 at 3:59 am
g.britton (10/13/2015)
Shouldn't your example output be:1 0 Apple
4 2 Apple
8 3 Apple
Guess it's "before and including"
😎
October 13, 2015 at 1:50 pm
jeffrey.sharp (10/13/2015)
Product_ID identity 1,1
Product_Purchased varchar(25)
1 Apple
2 Pear
3 Banana
4 Apple
5 ...
October 13, 2015 at 1:49 pm
arrjay (10/13/2015)
Hi there - For SQL Standard edition, would I need multiple licenses if I created multiple named instances on the same physical or virtual server?Thanks, Russell.
Quick answer is that...
October 13, 2015 at 1:29 pm
Quick thought, change the data type from datetime to datetime2, the value is out of range for the former.
😎
October 13, 2015 at 9:51 am
Quick question, have you considered turning on compression on those tables and indices, most likely more effective and almost no risk involved.
😎
October 13, 2015 at 1:48 am
ChrisM@Work (10/12/2015)
October 12, 2015 at 12:27 pm
eklavu (10/12/2015)
I'am having an issue fetching Chinese characters in a XML data type. It return questions mark (?).
Would you be able to advise me? TIA.
Below is the sample script.
DECLARE...
October 12, 2015 at 12:20 pm
Luis Cazares (10/12/2015)
crookj (10/12/2015)
djj (10/12/2015)
eccentricDBA (10/9/2015)
Ed Wagner (10/9/2015)
Luis Cazares (10/9/2015)
Eirikur Eiriksson (10/9/2015)
Ed Wagner (10/9/2015)
DonlSimpson (10/9/2015)
anthony.green (10/9/2015)
Ed Wagner (10/9/2015)
crookj (10/9/2015)
Ed Wagner (10/9/2015)
happygeek (10/9/2015)
Deadlock victim!Cost
Expense
Revenue
Tax
Tariff
Price Increase
Pint
Pitcher
Round
Parrotheads
Paradise
Snake Eyes (pair a dice)
G.I.Joe
DYJoe
October 12, 2015 at 12:14 pm
Viewing 15 posts - 4,351 through 4,365 (of 8,753 total)