ktflash

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 176 total)

Reply To: How to show table in one row

Ahoi,
for future posts:
https://qa.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

for current post:
The thing ur looking for is probably Pivot/Unpivot from SQL Server, theres examples of how to use it on google
I want to be the very best
Like no one ever was
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

June 7, 2022 at 12:52 pm

#4045614
Reply To: Iterate and reorganize subset of database tables
Duplicate Post i made because i couldnt see my own post/page 2 option.
Please ignore
- This reply was modified 2 years, 3 months ago by ktflash.
I want to be the very best
Like no one ever was
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
June 3, 2022 at 9:23 am

#4043695
Reply To: Iterate and reorganize subset of database tables

ScottPletcher wrote:
Why are using this setting: SORT_IN_TEMPDB = OFF?
That's generally a very bad idea overall, esp. for larger indexes.

Not sure, im just using the following which was suggested earlier unless...
I want to be the very best
Like no one ever was
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

June 3, 2022 at 9:15 am

#4043694
Reply To: Iterate and reorganize subset of database tables

HMHMHMH
Job has been doing fine for the few days i used the dbo.IndexOptimize
Now the job has been stuck for 4 hours on a single index rebuild while the Job previously...
I want to be the very best
Like no one ever was
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

June 3, 2022 at 5:46 am

#4043613
Reply To: Iterate and reorganize subset of database tables

Ok i am confused, i was replacing my "alter index reorganize" part with the "execution dbo.indexoptimize" within my script that iteratates through the for me relevant tables, job seems to...
I want to be the very best
Like no one ever was
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

May 31, 2022 at 4:49 am

#4041829
Reply To: Iterate and reorganize subset of database tables

Left a subcription
I want to be the very best
Like no one ever was
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

May 30, 2022 at 4:24 am

#4041331
Reply To: Iterate and reorganize subset of database tables

Thanks for the reply.
Weird that this is somehow not more public knowledge since the problem seems to be pretty impactful and somehow mentioned "no where" in most (popular) google results.
I want to be the very best
Like no one ever was
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

May 27, 2022 at 8:13 am

#4040118
Reply To: Iterate and reorganize subset of database tables

frederico_fonseca wrote:
I'll let Jeff do some chopping but WHY Reorganize? this should be avoided almost at all costs (very few exceptions)
Not aware of that, also can't seem to find this...
I want to be the very best
Like no one ever was
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

May 27, 2022 at 4:08 am

#4040025
Reply To: Row wise sum based on condition
```
select id
      ,name
      ,no
      ,sum(no) OVER(PARTITION BY id, name)
from mytable
```
I want to be the very best
Like no one ever was
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
May 17, 2022 at 4:23 am

#4034069
Reply To: DateDiff - Data Type conversion Issues
You could check the rows that cause the conversion error.
The function returns null if the row fails to cast, so you only get the rows that fail to convert.
```
I want to be the very best

Like no one ever was
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
```
May 16, 2022 at 7:50 am

#4033551

Reply To: Getting into an existing DBMS

It has been 4 years since i started this topic and joined this forum (boy time flies by in hindsight).

I told my boss i got a new job offer (after...

I want to be the very best
Like no one ever was

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

May 2, 2022 at 5:13 am

#4025284

Reply To: Handle TSQL Session exections terminated by users

[/quote]

Please post the entire code for the delete loop , the CREATE TABLE statement for the table you're deleting from, and all indexes, FKs, and triggers associated with the table...

I want to be the very best
Like no one ever was

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

April 22, 2022 at 5:57 am

#4020328

Reply To: display available amount from setup table range

Did you miss a zero in 55000000, should it actually be 550000000?
Am i wrong or should the actualy result of 550000000 be:

SeqNo Used

1 60000000.00

2 190000000.00

3 250000000.00

4 50000000.00

Not sure...

I want to be the very best
Like no one ever was

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

April 21, 2022 at 10:37 am

#4019863

Reply To: How to get the output of SQL Server Activity Monitor using SQL script?

Heres a some selection of columns u can query from DMVs that SQL Server offers.

SELECT  DER.session_id
   ,DER.status
   ,txt.text
   ,DER.user_id
 ...

I want to be the very best
Like no one ever was

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

April 21, 2022 at 9:41 am

#4019834

Reply To: How do you change the whole theme of SQL Server 2014 Management Studio to black?

The only thing i am aware of is the "inofficial" dark theme which can be unlocked, but does not change object explorer.

For available options, the best thing to do in...

I want to be the very best
Like no one ever was

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

March 29, 2022 at 11:36 am

#4007592

Viewing 15 posts - 1 through 15 (of 176 total)