Alan Burstein

Forum Replies Created

Viewing 15 posts - 1,291 through 1,305 (of 2,463 total)

RE: What are your five most common T-SQL commands

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...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

August 25, 2015 at 8:09 pm

#1822373
RE: What are your five most common T-SQL commands

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...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

August 25, 2015 at 7:50 pm

#1822370
RE: Fine tuning Queries

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...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

August 20, 2015 at 12:05 pm

#1821508
RE: text mining

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...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

August 19, 2015 at 11:32 am

#1821142
RE: Collecting contents of a package

Hey Charmer. I will get back to you tomorrow. (Long day)
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

August 17, 2015 at 10:51 pm

#1820612
RE: Unable to link data from data pulled from XML

drew.allen (8/17/2015)
Eirikur Eiriksson (8/14/2015)
drew.allen (8/14/2015)
Eirikur Eiriksson (8/14/2015)
Further, I was only stating that with a properly written XQuery, using the text() function is much quicker, I was not commenting or comparing...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

August 17, 2015 at 10:47 pm

#1820611
RE: Unable to link data from data pulled from XML

Eirikur Eiriksson (8/14/2015)
Alan.B (8/13/2015)
drew.allen (8/13/2015)
Alan.B (8/13/2015)
Just to add to Drew's excellent solution, not only would you want to use the value() method over the query method here, you should include...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

August 17, 2015 at 10:19 pm

#1820610
RE: The Tally Table

Jeff Moden (8/14/2015)
Alan.B (8/14/2015)
BobAtDBS (8/14/2015)
I have read Jeff's article, both in the past and an hour ago. His examples aren't things we do at the TSQL level very often....
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

August 17, 2015 at 10:14 pm

#1820609
RE: The Tally Table

BobAtDBS (8/14/2015)
I have read Jeff's article, both in the past and an hour ago. His examples aren't things we do at the TSQL level very often. I'm wondering...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

August 14, 2015 at 3:57 pm

#1820239
RE: The Tally Table

g.britton (8/14/2015)
I just wish it wasn't called a "Tally" table. I don't tally things, I count them. fwiw I usually call my "tally" table "N" to reflect it's relation...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

August 14, 2015 at 9:12 am

#1820099
RE: Unable to link data from data pulled from XML

drew.allen (8/13/2015)
Alan.B (8/13/2015)
Just to add to Drew's excellent solution, not only would you want to use the value() method over the query method here, you should include the text() node...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

August 13, 2015 at 9:05 pm

#1819939
RE: Getting CPU Core count for licensing

Take a look at:
http://basitaalishan.com/2014/01/22/get-sql-server-physical-cores-physical-and-virtual-cpus-and-processor-type-information-using-t-sql-script/%5B/url%5D
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

August 13, 2015 at 2:14 pm

#1819890
RE: Collecting contents of a package

Charmer (8/13/2015)
Hi Friends,
I am trying to collect the metadata of a package in SSIS. What are the securities are needed to collect a metadata of a package?
since I am testing...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

August 13, 2015 at 2:04 pm

#1819882
RE: Unable to link data from data pulled from XML

Just to add to Drew's excellent solution, not only would you want to use the value() method over the query method here, you should include the text() node in your...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

August 13, 2015 at 1:41 pm

#1819874
RE: Introducing the Set-based Loop

Great article Luis! 5 Stars sir! I just finished reading it again and it's an excellent article; I can't wait to see more (you are going to write more articles...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

August 13, 2015 at 12:27 pm

#1819842

Viewing 15 posts - 1,291 through 1,305 (of 2,463 total)