Viewing 15 posts - 2,356 through 2,370 (of 59,066 total)
Just to be sure, an index "rebuild" won't do a move. It must be a CREATE INDEX that matches the currently existing index in all ways and it must have...
November 28, 2022 at 8:16 pm
I have 10-15 tables I would like to move to help balance the drive usage on that server. The tables I'm moving are just for reporting by the front-end...
November 28, 2022 at 4:46 pm
Just to add to this... I've found that the absolute scariest datatype is when people use the wrong datatype to store data, no matter what it is.
My recent favorite examples...
November 28, 2022 at 4:38 pm
The real risk is you forgetting to use the "Copy Only" functionality. 😀 You can tell I've "never had that problem before", right? 😀 I've made that mistake a couple...
November 28, 2022 at 3:38 pm
As a bit of a sidebar, having only 16GB of RAM on a Developer Server where production code is developed and unit tested and has restores done so frequently seems...
November 28, 2022 at 3:35 pm
Yes... you can backup to anywhere you can reach or the server can reach. There are a couple of ways to do it and, rather than me forgetting something, have...
November 28, 2022 at 5:32 am
ALTER TABLE UserLog DROP CONSTRAINT PK__UserLog__7F8B815172CE9EAE WITH (MOVE TO HISTORY)
USE TestDB GO
CREATE UNIQUE CLUSTERED INDEX UIX_UserLogID ON UserLog(UserLogID) ON [PRIMARY]
That'll certainly fill up your log file! When you drop...
November 28, 2022 at 5:17 am
Sounds to me like Tenant/Year might be the way to go for the queries, then. Don't be alarmed by the high fragmentation that will occur on that clustered index. It's...
November 28, 2022 at 4:47 am
"Learning by example" opportunity here... spend some time looking things up on the web, as suggested in the code below.
And, like Frederico suggests, learn how to use "Object Aliases" and...
November 27, 2022 at 4:08 am
Clustered and non-clustered indexes are all stored in the data file (MDF/NDF files). What you may not know is that the Leaf Level of the Clustered Index IS the actual...
November 27, 2022 at 2:28 am
1)Loading data in a grid (by tenant,year)
Just one tenant at a time?
November 27, 2022 at 2:12 am
you really need to read the manuals for MySQL - datediff in Mysql is totally different of that for SQL Server hence the error you get.
in mysql you would...
November 27, 2022 at 2:00 am
Hello Jeff and thank you very much for your answer. You're right. My mistake. I thought I was in a MySql forum.
About the issue....you're sure that the function to...
November 27, 2022 at 1:59 am
I just noticed that "substring_index" isn't the name of a alias here... it's the name of a function and that function doesn't exist in SQL Server. You should let people...
November 26, 2022 at 12:26 am
Viewing 15 posts - 2,356 through 2,370 (of 59,066 total)