Viewing 15 posts - 1,111 through 1,125 (of 59,066 total)
The intention was to know the reason do we need to bother about fragmentation for tables with 10's or few 100's of pages. I see dev team...
September 12, 2023 at 8:18 pm
I agree with Phil. Posting inserts to populate the test table with data will help a whole lot.
Also, the code you posted isn't from SQL Server but, since...
September 12, 2023 at 7:51 pm
And, sorry... I was reading and answering from top down. You and the OP got all this together.
September 12, 2023 at 3:12 pm
If you just want an id you can just add ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) id, as a column to the query to get a sequential id column....
September 12, 2023 at 3:10 pm
There is also JSON download in that link:
But, not the ID column the OP is looking for.
September 12, 2023 at 3:03 pm
Simple question.
Who is the Brent Ozar of cloud computing ie all you need to know about SQL management and options in the cloud the does and don't of DBA...
September 12, 2023 at 2:54 pm
Step 1 would be to get into the habit of using the 2 part naming convention. That doesn't have so much to do with performance in this case (although there...
September 12, 2023 at 2:51 pm
I agree with Phil. Posting inserts to populate the test table with data will help a whole lot.
Also, the code you posted isn't from SQL Server but, since you posted...
September 12, 2023 at 2:24 pm
Sorry... second look at the code I posted said it was wrong and took it down.
September 12, 2023 at 1:35 pm
The intention was to know the reason do we need to bother about fragmentation for tables with 10's or few 100's of pages. I see dev team asking question...
September 12, 2023 at 1:27 pm
If you are only moving the application databases (not the system databases). You can just detach the databases, move the database files to a different location then...
September 11, 2023 at 9:36 pm
Just remember... your favorite bloggers may not actually be correct. 😉
September 11, 2023 at 9:33 pm
My recommendation is this... go to all of the BBFAATT (a "Moden-ism for Books, Blogs, Forums, Articles, AI, Talks, and 'Tubes and is pronounced as "bee-bee-fat" and can be bleated...
September 11, 2023 at 8:32 pm
As a bit of a sidebar, renaming backup files destroys the ability to use the backup information stored in MSDB for research. If you want to name something, it should...
September 11, 2023 at 7:48 pm
So, I've thought that what I could do is migrate one of the apps I'm responsible for, into an Azure instance, using my Visual Studio Subscription monthly credits.
My...
September 11, 2023 at 7:06 pm
Viewing 15 posts - 1,111 through 1,125 (of 59,066 total)