Viewing 15 posts - 1,381 through 1,395 (of 7,187 total)
case
when (sn_type='De-Activated' and sn_status='COMP')
or (sn_type='Re-Activattion' and sn_status='N-CO')
then created_date
WHEN sn_status <> 'COMP' and sn_type='De-Activated'...
July 5, 2017 at 5:50 am
June 29, 2017 at 7:51 am
Do you have SET QUOTED_IDENTIFIER OFF anywhere in your code, or is your ODBC driver configured to set it to OFF?
John
June 27, 2017 at 3:42 am
Start with sys.sequences, which exposes most of the information you're looking for.
John
June 26, 2017 at 3:40 am
I know the example you posted is probably a massive simplification, but for that you don't need a loop at all. It's likely that you'll be able to rewrite your...
June 23, 2017 at 2:01 am
You need to use a splitter function to split the string into its individual elements.
John
June 22, 2017 at 9:27 am
Luis Cazares - Thursday, June 22, 2017 7:55 AMThat looks so similar to mine 😛
Almost identical......
June 22, 2017 at 8:00 am
Something like this, maybe. Although I'm a bit puzzled how there are two base tables in your execution plan, but only one in the query you posted. If any of...
June 22, 2017 at 7:33 am
You've got some large differences between the estimated and actual number of rows for those clustered index scans, suggesting that your statistics might not be up to date. And the...
June 22, 2017 at 7:14 am
Do you have the necessary indexes in place on the table to support this query?
John
June 22, 2017 at 4:39 am
If it's not shown in the DETA report? If you're talking about indexes, you might consult the missing indexes DMVs, one of which I think does show the anticipated percentage...
June 22, 2017 at 4:20 am
You can avoid a loop by using a Numbers (or Tally) table. You can create your own table, or spin it up on the fly as I've done below. This...
June 22, 2017 at 2:46 am
The transaction log for database is full due to 'ACTIVE_TRANSACTION'
The only solution that I found so far is DBCC SHRINKFILE.
June 21, 2017 at 8:39 am
You can't, unless you already had something in place to capture such events. If you're lucky, you may find something in the default trace. Do any of your...
June 21, 2017 at 8:15 am
Viewing 15 posts - 1,381 through 1,395 (of 7,187 total)