Viewing 15 posts - 4,336 through 4,350 (of 8,753 total)
sandeepraichura (10/26/2015)
Did anyone came across...
October 26, 2015 at 5:01 pm
Ratheesh.K.Nair (10/25/2015)
We are observing very strange scenario in which some relationships are getting removed from tables. We havent deleted any tables? Can anyone help me understand or any...
October 25, 2015 at 9:19 am
Ed Wagner (10/23/2015)
anthony.green (10/23/2015)
Ed Wagner (10/23/2015)
anthony.green (10/23/2015)
djj (10/23/2015)
anthony.green (10/23/2015)
Ed Wagner (10/22/2015)
MathSchool
Study
Invest
Risk
Assessment
Process
Inflation
October 23, 2015 at 7:37 am
ZZartin (10/22/2015)
Ed Wagner (10/22/2015)
eccentricDBA (10/22/2015)
DonlSimpson (10/22/2015)
Ed Wagner (10/22/2015)
anthony.green (10/22/2015)
crookj (10/22/2015)
anthony.green (10/22/2015)
djj (10/22/2015)
anthony.green (10/22/2015)
Ed Wagner (10/22/2015)
BL0B_EATER (10/22/2015)
crookj (10/22/2015)
anthony.green (10/22/2015)
Ed Wagner (10/22/2015)
DumbledoreProfessor
Gandolf
Beard
Hair
Biker
Leather
Cow
Tipping
Tractor
Hay Ride
Allergies
allegories
Euphemism
Schism
Ism^2
October 22, 2015 at 11:19 am
mw112009 (10/22/2015)
I am simply trying to get a listing of table_name , col_name for those tables that...
October 22, 2015 at 11:04 am
sam-433147 (10/22/2015)
OKI see what you mean
but what about xml that exceed the varchar(max)?
If it exceeds the 2Gb limit then you have two options, chop it into 2GB chunks or export...
October 22, 2015 at 10:16 am
Stewart "Arturius" Campbell (10/22/2015)
martin.whitton (10/22/2015)
Of course, if you have more than 2^21 columns in your database, it will return an error ... 😀
if one has that many columns, they will...
October 22, 2015 at 10:14 am
sam-433147 (10/22/2015)
how can i insert the declaration
<?xml version="1.0" encoding="UTF-8"?>
to my query?
declare @tbl table(Color varchar(20))
insert into @tbl(Color)
values ('Green')
insert into @tbl(Color)
values ('Red')
select Color
from @tbl Colors
FOR XML AUTO, ROOT ('MyColors'), ELEMENTS...
October 22, 2015 at 5:04 am
nadersam (10/19/2015)
Unfortunately the lag function is not supported on the servers on site, they have SQL Server 2008.Any other option please?.
Self-join the character list cte is another option
😎
October 19, 2015 at 4:31 am
Quick question, is the new install running under the same credentials as the old one? Looks like a simple permission issue.
😎
October 18, 2015 at 12:00 pm
Thanks for the question Junior.
Given the answers it could as well have been "Pick the combination of two correct dates";-)
😎
October 18, 2015 at 10:39 am
Quick solution
😎
USE tempdb;
GO
SET NOCOUNT ON;
DECLARE @INPUT_STR VARCHAR(500) = 'WWWWWWHY DDDDDDDDDDDOOOOOOOOO YYYYYYYYOOOOOOOOOOOOOOOOOUUUUUUUUUU WWWWWWWWWWANNNNNNNNNNNNNTTTTTTT TOOOOOOOOO DOOOOOOOO TTTTTTTTHIIIIIIIIIIISSSSSSS??????????';
;WITH...
October 18, 2015 at 8:29 am
Quick suggestion, query sys.indexes to check if the columnstore index is disabled or not before attempting to manipulate the data.
😎
October 18, 2015 at 12:14 am
Quick thought and further on Jeff's fine answer, observing the wait stats during the operation usually gives a good indication of whether to alter the batch size or even change...
October 17, 2015 at 4:44 am
Another quick solution
😎
SELECT
MIN(T.hierarchyid) AS [hierarchyid]
,T.hierarchyval
FROM #test T
GROUP BY T.hierarchyval;
The two solutions posted are close in performance or rather lack there of,...
October 16, 2015 at 11:04 pm
Viewing 15 posts - 4,336 through 4,350 (of 8,753 total)