webrunner

Forum Replies Created

Viewing 15 posts - 466 through 480 (of 1,189 total)

RE: The End

manik123 (12/31/2014)
Very nice question.... +1 😀
+2 😀
Thanks, Steve!
I wish everyone out there in SSC land a healthy and happy new year.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

December 31, 2014 at 8:52 am

#1767204
RE: List denied permissions and undo a DENY

Thanks, Gianluca! That was the information I needed.
Thanks also Shafat for your response.
Sincerely,
webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

December 19, 2014 at 7:49 am

#1765710
RE: Execution Plan reuse

Good question, thanks.
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

December 17, 2014 at 2:22 pm

#1765287
RE: I have no id

Thanks for the question. I fell for the trick and got it wrong, but now I know why.
Thanks again!
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

December 17, 2014 at 2:13 pm

#1765285
RE: Need help with DB user permissions error

Lowell (12/9/2014)
i think it's a scope issue.
it looks like technically there are two [myuser] users, in two different databases.
they only get JOINED to be the same person when you use...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

December 9, 2014 at 12:24 pm

#1763628
RE: Need help with DB user permissions error

Thanks for your reply!
First, some additional info.
1. It is definitely a table, not a view.
2. I did get back the user 'mylogin' with the suser_name() query that you suggested.
3. Curiously,...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

December 8, 2014 at 1:15 pm

#1763352
RE: Difference between Delete,Truncate and drop

ksatpute123 (12/1/2014)
bharatmehra76 (11/30/2014)
Can you tell me reason behind this?
You can start with this:
http://blog.sqlauthority.com/2007/12/26/sql-server-truncate-cant-be-rolled-back-using-log-files-after-transaction-session-is-closed/
http://www.sqlservercentral.com/Forums/Topic1488704-391-1.aspx
If you are a beginner then you need to understand how DELETE, DROP and TRUNCATE work instead...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

December 1, 2014 at 8:24 am

#1761746
RE: Difference between Delete,Truncate and drop

Great question, thanks!
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

December 1, 2014 at 8:23 am

#1761745
RE: In The Beginning

"3114 B.C. is the start of the Mayan calendar."
I wonder whether the Mayans used "May-SQL" 😀
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

November 25, 2014 at 7:52 am

#1760815
RE: Calculate distance between 2 coordinates/latlong

Really cool. Thanks!
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

November 24, 2014 at 2:01 pm

#1760610
RE: What's changed recently?

ianstirk (11/16/2014)
Hi
Typically only a small number of rows have changed recently (unless there's been a table defrag), I want a small number of rows, so 22 seems appropriate... 11 or...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

November 19, 2014 at 2:05 pm

#1759640
RE: Are ETL/DW techniques best for incremental extracts?

Thanks for this reply!
I'll review your suggestions and come up with a design. I see what you mean about tracking the history/auditing can be treated separately.
The particular problem I have...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

November 17, 2014 at 2:27 pm

#1759094
RE: What's changed recently?

Thanks for this! But why select the top 22 only?
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

November 15, 2014 at 8:54 pm

#1758819
RE: IN or OR

Thanks for the question. However, something about the list of radio button options made me think the only option worth picking was that the queries give the same result, which...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

November 2, 2014 at 1:49 pm

#1756220
RE: Friday Shirts

Iwas Bornready (10/31/2014)
I guess (wrong) that since 7 was your favorite number and you were giving away 7 points, it had to be 7. How cruel is that?
I know! I...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

October 31, 2014 at 8:12 am

#1756045

Viewing 15 posts - 466 through 480 (of 1,189 total)