Viewing 15 posts - 3,826 through 3,840 (of 6,041 total)
The following will easily give you what you want, without resorting to a loop. It basically just applies row_number() across a resultset to get a sequential set of numbers, multiplying...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 29, 2015 at 7:39 am
Not just for data scientists, basic statistical analysis can also be incorporated into a database at the operational level. For a dashboard application that monitors ETL processes, I leverage the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 29, 2015 at 7:22 am
Confirm that both tests, the straight select and then the insert / select, are performed in the same SSMS query window, using the same session and default session settings. Settings...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 28, 2015 at 9:00 am
Confirm is no primary key or unique index with "ignore_dup_key = on" or "instead of" triggers.
Also, what happens if you simply SELECT .. INTO <table> ?
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 28, 2015 at 8:21 am
dlsilsbury 63952 (5/28/2015)
Eric M Russell (5/27/2015)
No. System views are those distributed with SQL Server. There is rarely a reason to mark a user created object as 'system'.
Thanks, I understand this...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 28, 2015 at 7:11 am
The default timeout can be overridden at connection or command level within VB programming code.
http://stackoverflow.com/questions/1354271/timeout-setting-for-sql-server
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 27, 2015 at 3:17 pm
This is not a MS Access forum and a database is not a bowl of fruit, but here is how you exclude specific rows from a SQL query.
select Fruit
from...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 27, 2015 at 3:03 pm
GETDATE() returns local time and GETUTCDATE() returns UTC time.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 27, 2015 at 2:58 pm
One of the advantages of a medieval style IT shop, where the rules are not spelled out on paper, is that you as the DBA can simply lord it over...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 27, 2015 at 11:48 am
Depending on the organization, I'm not opposed to allowing Developers read-only access to production, especially if they are expected to wear the Data Analyst hat on occasion. Even more advanced...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 27, 2015 at 10:57 am
dlsilsbury 63952 (5/21/2015)
...Out of interest how do you mark a view as a system view?
No. System views are those distributed with SQL Server. There is rarely a reason to mark...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 27, 2015 at 9:24 am
Kyrilluk (5/27/2015)
Eric M Russell (5/27/2015)
Jeff Moden (5/27/2015)
Kyrilluk (5/27/2015)
Eric M Russell (5/26/2015)
Kyrilluk (5/26/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 27, 2015 at 8:06 am
Kyrilluk (5/27/2015)
Eric M Russell (5/27/2015)
Kyrilluk (5/27/2015)
Eric M Russell (5/26/2015)
Kyrilluk (5/26/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 27, 2015 at 8:01 am
Jeff Moden (5/27/2015)
Kyrilluk (5/27/2015)
Eric M Russell (5/26/2015)
Kyrilluk (5/26/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 27, 2015 at 7:50 am
Kyrilluk (5/27/2015)
Eric M Russell (5/26/2015)
Kyrilluk (5/26/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 27, 2015 at 7:29 am
Viewing 15 posts - 3,826 through 3,840 (of 6,041 total)