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...
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...
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...
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> ?
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...
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
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...
May 27, 2015 at 3:03 pm
GETDATE() returns local time and GETUTCDATE() returns UTC time.
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...
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...
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...
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)
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)
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)
May 27, 2015 at 7:50 am
Kyrilluk (5/27/2015)
Eric M Russell (5/26/2015)
Kyrilluk (5/26/2015)
May 27, 2015 at 7:29 am
Viewing 15 posts - 3,826 through 3,840 (of 6,041 total)