BenWard

Forum Replies Created

Viewing 15 posts - 61 through 75 (of 264 total)

RE: Core T-SQL

rlortega (11/25/2013)
So what minimum T-SQL skills are necessary if you're a DBA, not a developer?
That really depends how many DBAs there are in your company. If there are many, perhaps...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

November 25, 2013 at 8:30 am

#1668832
RE: Core T-SQL

I've been working with SQL Server for 7 years and have still not once had to use APPLY for anything... Do I not meet the minimum requirements to work with...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

November 22, 2013 at 2:02 am

#1668320
RE: Querying an Imported Excel Sheet... I know... I feel the same way about Excel as you do.

Thanks pal I'll have a read of your article and post how it goes.
Cheers.
Ben
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

November 13, 2013 at 2:56 am

#1665969
RE: joins

Hi Surya, this is a very vague scenario and could involve any number of different joins and clauses depending on your data structure. Do you have example table definitions and...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

November 8, 2013 at 5:19 am

#1665066
RE: joins

Hi,
This article http://www.made2mentor.com/2011/02/different-types-of-joins/ covers the basics.
For more in depth details Microsoft's own article on it is very comprehensive. http://technet.microsoft.com/en-us/library/ms191517(v=sql.105).aspx
If you have any specific scenarios in which you need some help...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

November 8, 2013 at 4:47 am

#1665051
RE: What's in a Name?

djackson 22568 (10/29/2013)
Beatrix Kiddo (10/29/2013)
david.irvine 7489 (10/28/2013)
A long time ago, I knew someone whose surname was Null. Now that I work with databases I often wonder if any of...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

October 29, 2013 at 9:06 am

#1662401
RE: What's in a Name?

nice one Mr Pierce
😉
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

October 29, 2013 at 5:25 am

#1662289
RE: What's in a Name?

not exactly on topic but I have numerous people on the phone who don't listen to my email address. it's a bit unusual in that it is a .org.uk domain....
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

October 28, 2013 at 7:21 am

#1661950
RE: Error converting string to date

You sir, are a legend.
Thanks very much - I've not used PATINDEX before, I'll take a look into that in more detail.
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

May 2, 2013 at 6:48 am

#1611872
RE: Error converting string to date

alas this table is built from daily data files going back over a number of months so getting the software house to re-export some of those csv files isn't an...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

May 2, 2013 at 6:20 am

#1611859
RE: Error converting string to date

ooh interesting... I've just checked again and all the 2011-01-01 type dates returned true by isdate (im expecting yyyy-mm-dd) are returning records where the dd part is between 1 and...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

May 2, 2013 at 5:03 am

#1611843
RE: How to recover a SQL Server login password.

Michael Meierruth (3/6/2013)
And what's the point of what you're saying in your binary signature?
It's self-referential.
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

March 6, 2013 at 6:59 am

#1593926
RE: How to recover a SQL Server login password.

Michael Meierruth (3/6/2013)
paul.knibbs (3/6/2013)
SQLCharger (3/6/2013)
Guys,
Would this also work with Windows hashes as well?
That would be even more scary (if someone manages to get your Windows hash from a server). :unsure:
There's...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

March 6, 2013 at 4:19 am

#1593867
RE: How to recover a SQL Server login password.

Sigerson (3/4/2013)
we'll all have implanted RF chips
Until some quack attempting to make a quick buck publishes a dubious medical report based on 3 test patients who just so...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

March 4, 2013 at 9:16 am

#1593060
RE: How to recover a SQL Server login password.

excellent - thanks for the info.
I've decided to do some maths.
If you used a dictionary based brute force it might feasibly take less time I suppose depending on how...
Ben
^ Thats me!
----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

March 4, 2013 at 5:41 am

#1592969

Viewing 15 posts - 61 through 75 (of 264 total)