Viewing 15 posts - 5,851 through 5,865 (of 59,070 total)
The restore operation using WITH MOVE will allow you to rename the database and create new data files. However, the only thing that will change the code is changing...
December 16, 2020 at 5:25 am
One thing that few consider is that it might be "recompiles". We had a query that was taking "only" (way too long in my eyes) 100ms to execute. The problem...
December 16, 2020 at 5:22 am
Thanks!! That appears to work... Now I just have to figure out how to get 'MyTimeSpent' to display as day plus hours or as full day with decimal.. Such...
December 16, 2020 at 4:23 am
"Don't fix if it ain't broken" - this is used far too often.
the bridge has to collapse for them to decide its time to replace those rusted bolts.
BWAAAAA-HAAAAA-HAAAAA!!!! It...
December 16, 2020 at 3:22 am
You have some values that have leading zeros. Must the leading zeros be preserved? If so, then not all of the columns are actually INTs as you said. ...
December 16, 2020 at 3:04 am
In SQL 2016, it's rarely a waste of disk space. Specifying ROW compression is standard procedure for all tables unless there's a specific reason not to.
"Standard Procedure for ALL...
December 16, 2020 at 2:58 am
We've been using Teams for a lot of communication, but sometimes it's nice to get up and walk over to someones' desk, or turn the chair to chat with...
December 15, 2020 at 11:39 pm
Hi Guys!
I start the WITH statement without the semi column ; then I will test also starting with the semi column. I had to rewrite all of it and...
December 15, 2020 at 12:52 am
You also use the term "adjacent" which is a spatial concept that doesn't apply to the table. A table is an abstract unordered set of rows.
Except for HEAPs, that's...
December 15, 2020 at 12:48 am
Hi all. I have already read about SQL Server Profiler. But I can't understand what means "Writes" there. For example, I have a query that has 13500 Reads and...
December 14, 2020 at 11:39 pm
My boss manually deleted the backlog in chunks on Friday and things appear to have been fine over the weekend. I'll know a bit more definitely when the reports...
December 14, 2020 at 11:29 pm
You have some values that have leading zeros. Must the leading zeros be preserved? If so, then not all of the columns are actually INTs as you said. ...
December 14, 2020 at 11:08 pm
I was too enthousiastic. What I did was I only took the 7 character long records (WHERE LEN(column1)=7) and then applied the LEFT functions as indicatde above....
December 14, 2020 at 11:03 pm
ScottPletcher wrote:This has less overhead...
Just curious, Scott... how are you measuring "overhead" for this?
Actually, for this one, I just looked at the query plans. The other code is...
December 14, 2020 at 10:54 pm
Are you terminating the preceding statement with a semicolon?
You can start statements that begin with "WITH" with a semicolon:
;WITH ret AS(
Now, there's an interview...
December 14, 2020 at 10:45 pm
Viewing 15 posts - 5,851 through 5,865 (of 59,070 total)