Linked Server Tribulations In SQL Server
In this article, Thomas chronicles the difficulties of troubleshooting a linked server set up, with helpful tips and an exposé of a Linked Server UI flaw.
2014-08-05
5,606 reads
TCP/IP
Change the port number for connections to SQL Server
How to change the port number for connections to SQL Server.
2012-03-01
11,390 reads
Identify SQL Server TCP IP port being used
How do I find out what TCP/IP port SQL Server is using for a specific SQL Server instance? In this tip we look at different ways a database administrator can identify the port used by instance of SQL Server.
2011-10-28
6,353 reads
finding related tables on DB with no documentation or diagrams?
theres a rather large DB system on a server where i work. i have to link it to another large server DB. the prob is that theres no documentation or diagrams on what tables are related and what columns are for. are there any programs/qwueries that i can run on a DB that will allow […]
2004-04-16
3 reads
RE: Best data type for storing "Hours"
Smallmoney is 4 bytes and has a maximum of 214,748.3647 To hold the equivalent in decimal would be 9 bytes decimal(10,4)However if you are only storing to 2 decimal places then smallmoney would still be 4 bytes and a maximum of 214,748.3647 but numeric(9,2) is 5 bytes with a maximum of 9,999,999.99It depends if you […]
2004-04-15
RE: How can I connect to another database?
I do not understand well your question. In TSQL there is no such command as connect. First you have to connect to a server/database then you can issue TSQL commands. Of cours you can connect to the server by using QA, EM, and all other client tools or programming languages. What is exactly your question? […]
2003-11-27
1 reads
RE: pages clustered/non-clustered index
can anybody give info on this ? It's an important matter to us. Thanks a lot.
2003-08-26
1 reads
2003-08-20
1 reads
RE: Login fails
Yeah I'll have to drag them out of the closet, first I want some NT gurus look at. It's too wierd. On the client that's not part of the domain I connect to one of the SQL servers but not the other, and on the one I connect to event log on that server keeps […]
2003-07-11
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers