Viewing 15 posts - 5,491 through 5,505 (of 59,068 total)
Yeah, I want just the schema. But how do I import the sql file into the database to create a new table?
Bulk Insert the text file as a single...
March 13, 2021 at 2:37 am
The proprietary identity table property is not an attribute by definition, so it can never be a key. But it is let's bad programmers write their SQL as if...
March 12, 2021 at 1:27 am
I've got a DynamicsAX database that's seeing a significant amount of blocking despite having RCSI set and the connections using Read Committed.
Aren't most of the Clustered Indexes in DynamicsAX...
March 11, 2021 at 7:44 pm
p.s. Just noticed that they also list the old command of "SQLCMD -L" to find servers. I discovered very long ago that if the SQL Browser service on a server...
March 8, 2021 at 4:20 pm
Sometimes, you've just gotta love the internet search capabilities. Check out the following Google search for what you seek.
March 8, 2021 at 4:16 pm
Hello @jeff,
We use MAPS to collect SQL inventory from all servers, but MAPS cannot be automated.Are there any other free tools which can scan our network periodicaly and identify...
March 8, 2021 at 3:52 pm
And, using triggers, you can make the COMPRESSion and DECOMPRESSion transparent to the developers
Interesting... How do you make DECOMPRESSion transparent to SELECTs (for example) using...
March 8, 2021 at 3:31 pm
In a scenario, where 100 users over LAN open data entry application and edit values(in a grid) from 9 AM to 9 PM, wouldn't there be a speed issue,...
March 8, 2021 at 3:17 pm
If that box has 12,000 connections, you may have some software running against it or a stored procedure running that has "Connection Leaks". You should probably investigate what is making...
March 7, 2021 at 8:48 pm
And, using triggers, you can make the COMPRESSion and DECOMPRESSion transparent to the developers
Interesting... How do you make DECOMPRESSion transparent to SELECTs (for example) using triggers?
March 7, 2021 at 8:17 pm
Useful information
I can feel the spam getting ready to flow on this one... 😉
March 7, 2021 at 8:06 pm
Or you could just add a WHERE clause to filter them out as it's a table valued function.
Yes ... but my Splitter returns an Item No, and if...
March 7, 2021 at 4:53 am
Now that's a matter of opinion. I, for one, want it to return empty or null strings for any element that exists but isn't filled. One of the things I...
March 5, 2021 at 6:23 pm
Viewing 15 posts - 5,491 through 5,505 (of 59,068 total)