Viewing 15 posts - 1,276 through 1,290 (of 2,458 total)
Great article Johan. I work with people who swear by BIML and I see why. This is the kind of thing I have tried to do before without success. I'm...
September 10, 2015 at 7:58 am
Perhaps I'm not understanding this correctly but this seems to get the correct answer based on my interpretation of the requirement.
DECLARE @string varchar(1000) =
'ABNAGENDRACSURENDRADJITHENDRAXNRENDRABVEERNDRAXDRMNDRAXRVINDRABNAGENDRACSURENDRADJITHEN';
SELECT TOP 1 'A'+Item
FROM...
September 8, 2015 at 10:20 pm
Great article Greg. Concise, informative and to-the-point. I love Window Ranking Functions and could not live with out them.
One minor correction:
A ranking value is just a number, which...
September 2, 2015 at 5:23 pm
Books Online for this is actually pretty good. Its thorough and links to some other useful articles about TDE.
September 2, 2015 at 12:45 pm
That's most likely because you are running the package using your credentials which has rights to run the package and the SQL Agent (which runs as a Windows service) is...
September 2, 2015 at 12:27 pm
SQL-DBA (8/31/2015)
September 2, 2015 at 9:55 am
Great article Josh! I have not yet played around with SQL Server 2016 but, based on everything, Microsoft is trying to make it more "big data friendly". That would be...
September 2, 2015 at 9:40 am
Hope it's not too late to say, "Great article Eirikur!". I just finished reading this for a second time (there is a problem that I was struggling with that your...
September 1, 2015 at 2:59 pm
dwain.c (8/25/2015)
BTW. ...
August 26, 2015 at 8:11 am
Brandie Tarvin (8/24/2015)
USE MyDatabase;
GO
SELECT Table_Name, Column_Name
FROM INFORMATION_SCHEMA.Columns
WHERE Column_Name LIKE 'MyColumn%'
ORDER BY Table_Name, Column_Name;
--Find all tables containing a certain column name
Yep, Amen! I forgot this... This (and/or variations of) should have...
August 25, 2015 at 8:09 pm
I made a point at not looking at other people's replies. I use WHOISACTIVE and sp_askbrent quite a bit but that's not what you're looking for. I haven't been doing...
August 25, 2015 at 7:50 pm
Read the article Luis posted.
Without DDL, sample data there's not much help we can provide. That said, here's a couple bits of advice.
If you don't need that ORDER...
August 20, 2015 at 12:05 pm
Full text indexing may help but I don't know enough about it or have enough details about your requirement to say for sure. I do have a function, however, which...
August 19, 2015 at 11:32 am
Hey Charmer. I will get back to you tomorrow. (Long day)
August 17, 2015 at 10:51 pm
Viewing 15 posts - 1,276 through 1,290 (of 2,458 total)