Viewing 15 topics - 13,951 through 13,965 (of 284,001 total)
Topics
Started by
Posts
Last post
Hello, Attached sample query and actual plan, I want to further optimize the query and change the s…
11 replies
I tried GRANT EXECUTE ON OBJECT :: sys.sp.droprolemember TO John; GO Cannot find the object 'dropro…
3 replies
Hi all, I am attempting to use DMA to assess an upgrade from 2008 R2 to Asure SQL on VM. Our databa…
12 replies
How can I get a list of all database owners in an instance (not db_owners but actual owners) for ea…
1 replies
Is there a restriction of file size that can be imported into SQL? 5 gig, 10 gig???
6 replies
Im trying to copy the contents of my sql server backup .bak files to azure storage using azcopy. Im…
1 replies
Today’s tip is to think of something you’ve always wanted to do and never tried. http://voiceofthed…
1 replies
Previously we used to use transactional replication and that would allow reporting database to be d…
9 replies
I am working an exercise problem where the solution provided has a WHERE clause used in a way I hav…
15 replies
Hi All, I was asked to map all ojects that a specific group of users access in our DBs. I'v…
6 replies
Hi, I'd like to know why the page count is almost exactly doubled for a table with existing rows, h…
7 replies
Long story, I'll spare the details. I have a machine with SQL 2016 Standard installed. I would al…
3 replies
I need to write a query which will first update the table, then execute the job and if the job is s…
5 replies
Hi all, I want to get the basics right, and I am in the middle of pulling 1 million rows approx int…
3 replies
I’m running into issues checking integrity on large tables. ( e.g. over 100 million records and gr…
1 replies
Viewing 15 topics - 13,951 through 13,965 (of 284,001 total)