Viewing 15 posts - 3,316 through 3,330 (of 6,041 total)
SQL_Surfer (10/8/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 9, 2015 at 1:31 pm
You can do a brute force dictionary query against the sys.sql_logins table.
http://www.sqlservercentral.com/Forums/FindPost1623412.aspx
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 9, 2015 at 12:42 pm
When I say ad-hoc queries, I'm referring to scenarios where users are typing SQL into a query tool ad-hoc, or perhaps where an application has a search feature with an...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 9, 2015 at 9:23 am
There has been more than one occasion in the past where I would hire on full-time at a company and then conclude within the first 90 days that the job...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 9, 2015 at 9:09 am
thebrewersinaz (10/9/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 9, 2015 at 8:58 am
Kristen-173977 (10/9/2015)
...
The actual code to do the CSV part was trivial, but we did need to take care of properly quoting columns that had embedded commas, and then double-quoting any...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 9, 2015 at 8:17 am
EdVassie (10/8/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 9, 2015 at 7:53 am
terry999 (10/9/2015)
That is a good idea, it is simple to understand. I went for the permissions in the end.
All new data is protected. I can still...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 9, 2015 at 7:49 am
null
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 9, 2015 at 7:44 am
It seems to me that 6 GB is very low end for a database server today. I've got more memory than that on my laptop. Even 12 GB is low...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 9, 2015 at 7:42 am
For an OLTP database (medium size tables, single inserts, many users, mostly small repetitive queries), you want re-usable query plans as much as possible.
However, in a data warehouse (very...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 9, 2015 at 7:16 am
Markus (10/8/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 8, 2015 at 1:49 pm
The SQL query is executed server side, so it will run approximately the same, regardless of where it originates (SSMS, SSRS, stored procedure).
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 8, 2015 at 1:38 pm
Adding columns to a table requires an exclusive table level lock, so it may be in a blocked state.
Also, if the columns have a default value, then it's an...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 8, 2015 at 1:31 pm
Here is me getting assigned tasks:
Take a look at the email I just forwarded.
Figure out what's going on.
Fix it.
Let me know as soon as it's done.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 8, 2015 at 1:20 pm
Viewing 15 posts - 3,316 through 3,330 (of 6,041 total)