meta user
network profile
| bio | website | billfellows.blogspot.com |
|---|---|---|
| location | Kansas City, MO | |
| age | 38 | |
| visits | member for | 1 year, 11 months |
| seen | 2 hours ago | |
| stats | profile views | 140 |
Developer, devourer of pie, disciple of databases, dictator of datum, drinker of tea, delirious with alliterative devices
|
Feb 3 |
comment |
SQL Server - storing ulong as primary key While you have to deal with those limitations in the CLR, I wonder whether SQL Server is going to be able to do a damn thing with a varbinary(8)? I'd have to experiment but my assumption is that since it is binary data, you'll be looking at table scans for all your reads. I'm ignorant here so that may be off base. |
|
Feb 3 |
comment |
SQL Server - storing ulong as primary key So what about using a numeric type with 0 scale? That's what the default SEQUENCE object is going to use. |
|
Jan 30 |
comment |
Downloading image data type contain to desktop SQL Server 2008 Is SSIS an option? |
|
Jan 29 |
comment |
Is it possible to create a trigger on a table synonym in SQL Server? What would you hope to accomplish with creating a trigger against a synonym? Random what-if question or is there a business problem you hoped to solve with it? |
|
Jan 25 |
comment |
Local users access SQL Server correctly, but domain users don't return all the data This query would determine whether there are any tables with the same name in different schemas SELECT T.* FROM INFORMATION_SCHEMA.TABLES AS T INNER JOIN ( SELECT T.TABLE_NAME FROM INFORMATION_SCHEMA.TABLES AS T GROUP BY T.TABLE_NAME HAVING COUNT(1) > 1 ) DUPE(table_name) ON DUPE.table_name = T.TABLE_NAME |
|
Jan 23 |
comment |
Local users access SQL Server correctly, but domain users don't return all the data Is there any rhyme or reason to why the data is subsetted? Does it provide consistent, if incorrect, results? You are running the same query against the same database, right? Have you fully qualified your tables' schemas? I could see something like localuser.Table1 and domainuser.Table1 existing with different data in there and if your default schema is set to each of those, then a lazy query of select * from Table1 would yield the "wrong" results. |
|
Jan 14 |
revised |
Inserting rows into other table whilst preserving IDENTITY Tried to identify the questions |
|
Jan 14 |
answered | Inserting rows into other table whilst preserving IDENTITY |
|
Jan 14 |
suggested | suggested edit on Inserting rows into other table whilst preserving IDENTITY |
|
Jan 11 |
comment |
What is the difference between a “record” and a “row” in SQL Server? One propels a craft, the other is used by dirty hipsters to play music |
|
Jan 9 |
comment |
Is there a SQL Server equivalent to “OVERRIDING USER VALUE” I'm not sure I quite catch your meaning. A "normal" insert doesn't allow you to push a value onto an identity field. You have to explicitly tell SQL Server that you're going to supply the identity value via SET IDENTITY_INSERT ON. If you still want to prevent them, one could use an INSTEAD OF trigger to always bypass provided values. Am I missing something in your question? |
|
Jan 9 |
comment |
Remote queries and linked servers I can only assume the simplification of the question has lead to us missing something. In the provided query, why not simply use an Execute SQL Task with a Connection Manager pointed at the CRM database and skip the linked server? |
|
Jan 8 |
comment |
Using SSIS to download an attachment from Exchange/Outlook SSIS has a Script Task that allows you to do most anything in .NET so if you can write, you can probably have SSIS run it for you. I'm not sure if the pop3.dll in this question is strongly signed. If it is, then you push that into the GAC and SSIS should be able to run a similar set of code. |
|
Jan 7 |
suggested | suggested edit on How can I create a view that spans multiple databases? |
|
Jan 7 |
revised |
T-SQL Purpose of MAX in this Group By Query Reset code to not scroll |
|
Jan 7 |
comment |
T-SQL Purpose of MAX in this Group By Query My first guess is that they used the aggregation because they've missed a relationship between the INVESTMENTS table and the other two tables. |
|
Jan 7 |
suggested | suggested edit on T-SQL Purpose of MAX in this Group By Query |
|
Jan 3 |
revised |
SQL Server 2000 export database to csv No thanks needed |
|
Jan 3 |
suggested | suggested edit on SQL Server 2000 export database to csv |
|
Jan 1 |
comment |
Why would a SELECT INTO cause an arithmetic overflow? How's your patch level? |
