@ErikE depends on your database. Postgres and Teradata both have 'sql' functions. You write a 'function' and it really just does a preprocessing 'find and replace'. Nearly 0 overhead (just the small amount for the query rewrite).
I am unable to use an ODBC 64 bit driver with ssms 2012 running on sql server 2012 64 bit computer.
However, I believe that the 32 bit driver works.
My question is can I use ssms 2005 32 bit to create a linked server using ODBC on a 64 bit instance of sql server 2012?
I tried to do this, but w...
I found something interesting to me today.
By the way, I execute view (sys.dm_exec_connections) for listing active connections on SQL Server and got two rows. In client_net_address I got IP address of my own local machine.
Then, I turned on Cisco VPN Client and connect to one VPN profile, and w...
I have created a linked oledb/odbc connection to Pervasive SQL from SQL SERVER 2012:
USE [master]
GO
/****** Object: LinkedServer [KSLAP208] Script Date: 2/8/2013 10:38:55 AM ******/
EXEC master.dbo.sp_addlinkedserver @server = N'KSLAP208', @srvproduct=N'Pervasive ODBC Interface', @provider...
Typical coffee machines have two user-accessible compartments: one for water and one for coffee beans. Pouring water into the bean compartment kills most machines, the repairs cost a fortune.
Now here's an improvement (Schaerer Siena-2 if that matters)
this machine is permanently connected to...
I have created a linked oledb/odbc connection to Pervasive SQL from SQL SERVER 2012:
USE [master]
GO
/****** Object: LinkedServer [KSLAP208] Script Date: 2/8/2013 10:38:55 AM ******/
EXEC master.dbo.sp_addlinkedserver @server = N'KSLAP208', @srvproduct=N'Pervasive ODBC Interface', @provider...
@AaronBertrand Why is that? We amazingly did not lose power. Nobody in my town did which I think is a first. Newtown had like 99% outages after Sandy and Irene
@MarkStorey-Smith I had at least 3 ft everywhere with drifts 4-5 feet
@JNK well when I realized the storm was coming I should have considered not going. It was only a SQL Saturday after all. And Madeline was starting to get sick. I probably should have stayed home.
We are the same. 2-3 feet consistently, 4-5 foot drifts, plow left 6 foot snowbanks in some places. I need to figure out how to dig out my mailbox today.
I had a plow arranged (but I would have called a plow were I home, too - can't justify spending 10 hours out there doing something I can pay someone else $40 to do in 5 minutes)
To me, it seems like you should have a single answer that meets the OP's criteria. If you don't know which scenario they're in, get clarification. Seems awkward to me to have two different answers to the same question. At the very least they could be combined into one answer with two sections. — Aaron Bertrand18 secs ago
I wasn't the down-voter by the way. I just have this thing about same user -> two answer -> same question.
In my environment there is a database Sybase ASE 15, that I need to replace with a Microsoft SQL Server 2000-r2.
Many users access this database via some applications, that sometimes "forget" to commit a transaction, then idle indefinitely keeping the table lock. This has a terrible effect: all o...
Signs I'm not awake yet. Ran a demo query and couldn't find the option to open with PE. However, if I don't turn on actual execution plan, I won't have an export option...
If anyone needs a few pounds of lung butter, send a SASE to me and I'll be happy to return it
lol somebody comes crying about their user being turned off in the db because we shutoff the user for the person who sits besides them and just left the company... "Why did you turn off my user?" "Its not your user...you were sharing a user...like you're not supposed to." "Well, can you turn her back on?" "No!" lol
@DerekDowney It has helped people find me better on gmail and the like, I think. I've certainly gotten more emails because of it. And the SE team calls me jco now.
@jcolebrand no, I stepped in here because I needed to post a message to all rooms (which I do via voodoo in the chat window), and it was the first room I clicked on ;)
What you need is a driver table that has all the values you want to output. You can then left outer join this to the actual data:
SELECT count(notification.eid) as count
FROM (select distinct eid
from notification
) drivers left outer join
(select *
from notification
...
curry from Istanbul. white and red pepper from gaziantep. salt from antakya. chicken from Tyson. one of these components of my lunch is not like the other
What have you done wrong? You have selected all the columns from the address table, not realizing that one or more of them is incompatible with distinct. You can probably do the same thing by taking advantage of a MySQL feature called Hidden Columns:
select ad.*,
acc.companyname,
acc.acc...
dba.stackexchange.com/questions/15231/… @ConcernedOfTunbridgeWells lol Our datawarehouse is available 24/7 and it updates ever hour and 30 minutes and I get my ass chewed for it being to slow....
Can someone answer this? Not too familiar with `NEWID()`... http://stackoverflow.com/questions/14817235/generate-new-guid-in-sql-server-if-one-is-not-provided#comment20756102_14817235
http://dba.stackexchange.com/questions/34534/ssas-drillthough-limit Am I wrong in assuming that if your drilling down that far your kind of missing the point of SSAS.
@AaronBertrand Wait til/if you have 2 of them. There's a critical mass that you reach where you have a sustainable ecosystem of pestilence. Someone in my house has been sick since thanksgiving
Ok Change of plans I'm going to collect 24 hours of Deadlock data before posting a question as I may have a fix.
"There is no indexing on this table and I do no care if it is sequential. Eventually I will always be supplying the GUID value and this could come from a different system where it is a unique value and NOT always a GUID so I have this field as a NVARCHAR to make it a little more flexible."
There is no indexing on this table and I do no care if it is sequential. Eventually I will always be supplying the GUID value and this could come from a different system where it is a unique value and NOT always a GUID so I have this field as a NVARCHAR to make it a little more flexible. — Slee5 mins ago
Schema :
SubscriberId NewsletterIdCsv
------------ ---------------
1 48,51,94
2 43,22
3 33,11
4 90,61
I Need to get the count for each rows NewsletterIdCsv and then add all of them up to get a total count of all rows, for the basic row count I am doing the following...
@billinkc Since we are anticipating 1.5 billion rows, normalization was already considered, tried and tested and it turned out to be extremely slow, these are just our intermediate tables where we work off to prepare the final data. — Murtaza Mandvi32 secs ago
but we do it much worse. we store two columns in a table that are csv and the order of the csv matter because one column is a pair with the other column. Think of it like one column is latitude values and the other column is longitude values. So one column is 82,84,85 and one is 28,29,30 but really it represents (82,28) (84,29) and (85,30) for example.
Ugh counting comma's in a column. Storing non-sequential GUID's as NVARCHAR in a Heap table. What is going on today? Or is it always this bad and I'm usually just to busy to notice?
I am unable to use an ODBC 64 bit driver with ssms 2012 running on sql server 2012 64 bit computer.
However, I believe that the 32 bit driver works.
My question is can I use ssms 2005 32 bit to create a linked server using ODBC on a 64 bit instance of sql server 2012?
I tried to do this, but w...
I found something interesting to me today.
By the way, I execute view (sys.dm_exec_connections) for listing active connections on SQL Server and got two rows. In client_net_address I got IP address of my own local machine.
Then, I turned on Cisco VPN Client and connect to one VPN profile, and w...
I have created a linked oledb/odbc connection to Pervasive SQL from SQL SERVER 2012:
USE [master]
GO
/****** Object: LinkedServer [KSLAP208] Script Date: 2/8/2013 10:38:55 AM ******/
EXEC master.dbo.sp_addlinkedserver @server = N'KSLAP208', @srvproduct=N'Pervasive ODBC Interface', @provider...
Typical coffee machines have two user-accessible compartments: one for water and one for coffee beans. Pouring water into the bean compartment kills most machines, the repairs cost a fortune.
Now here's an improvement (Schaerer Siena-2 if that matters)
this machine is permanently connected to...
What you need is a driver table that has all the values you want to output. You can then left outer join this to the actual data:
SELECT count(notification.eid) as count
FROM (select distinct eid
from notification
) drivers left outer join
(select *
from notification
...
Schema :
SubscriberId NewsletterIdCsv
------------ ---------------
1 48,51,94
2 43,22
3 33,11
4 90,61
I Need to get the count for each rows NewsletterIdCsv and then add all of them up to get a total count of all rows, for the basic row count I am doing the following...
