SQL Server extended stored procedure – xp_servicecontrol
In SQL server there is an undocumented extended stored procedure called xp_servicecontrol. You can use this to start/stop and view ... Läs mer »
In SQL server there is an undocumented extended stored procedure called xp_servicecontrol. You can use this to start/stop and view ... Läs mer »
När det gäller rättigheter för användarna i databaserna finns det ingen möjlighet att se detta i SQL Server Management Studio ... Läs mer »
First of all, I am not a fan of triggers because of a number of reasons, but i will not ... Läs mer »
Today I just wanted to have a little fun, while at the same time brushing off my T-SQL skills. As ... Läs mer »
Dag två i ett kyligare Vegas fortsatte för mig med sessionen "Understanding Statement Execution and Optimizing Stored Procedures". Också den ... Läs mer »
Today I stumbled over a nice list of documented and undocumented DBCC commands. I verified the content against SQL Server ... Läs mer »
When you think about monitoring SQL Server instances, you probably often think about monitoring that the service is up, performance, ... Läs mer »
Som vi skrivit om tidigare så finns det möjlighet att slippa den tid det tar för datafilen att växa genom att ... Läs mer »
If you would like to query the ERRORLOG with T-SQL you have the undocumented procedure SP_READERRORLOG. But as it's a ... Läs mer »
EDIT: Also read this blogpost: https://sqlservice.se/sv/start/blogg/sql-azure-followup.aspx , that gives more context to the findings in this post. Today we will ... Läs mer »
Alright, so you get this error when you process your dimension. You look carefully throug your data looking for duplicate ... Läs mer »
Hi, at the latest PASS conference i Seattle I took part in several sessions on change tracking, but was very ... Läs mer »
Meddelandet nedan ser man inte så ofta, tack och lov. Dock har jag nu stött på det. Msg 666, Level ... Läs mer »
A HEAP in SQL Server is a table without a clustered index, and in this blog post I'll show you ... Läs mer »
In SQL server, you can klii an active process using the command KILL <SPID> causing it to roll back any ... Läs mer »
I have a proposal to enhance the T-SQL JOIN syntax, to simplify writing joins that use an existing PK/FK relationship. ... Läs mer »
In SQL server there is an extended procedure, called xp_cmdshell, which you can use to execute commands and programs outside ... Läs mer »
As some of you might remember, I published this https://sqlservice.se/sv/start/blogg/sql-server-mystery-hekaton-tables-and-hekaton-procedures.aspx blogpost back in June, when I stumbled upon a mysterious ... Läs mer »
Denna vecka har jag tittat lite på prestandaproblem i SQL Server orsakade av parametersniffning. Jag tänkte skriva en längre blogpost ... Läs mer »
Ibland vill man veta vilka tabeller som tar upp utrymmet i en vissa databas, till exempel om du upplever ökad ... Läs mer »